Natural Remedy Inc

Ernie Colon


NBM Publishing

Colon


Inner Sanctum: Tales of Horror, Mystery and Suspense (The Inner Sanctum Mysteries)

Ernie Colon (Hardcover) NBM Publishing 2011-12-07


Price: $16.99

Answers

How do I switch a list of names and numbers separated by a colon?
" SAY --- WHO IS THAT " - JACKIE JOKERS ( Harvey ) # 2 May 1973 Cover: Ernie COLON

I have a list of people and their ID numbers after a colon between.
Example:
Abe: 22
Bob: 67
Candy: 12
Doris: 32
Ernie: 45
Ethel: 67
change this list (actually 200) to:
12: Candy
22: Abe
32: Doris
45: Ernie
67: Bob
67: Ethel

I am using Word. I have Excel, but I don't know enough about it.


After copy that list to Excel, paste it starting in cell A1, then paste this in B1
=MID( A1, SEARCH( ":", A1)+1,500)&":"&LEFT( A1, SEARCH( ":", A1)-1)

And copy cell B1 down to the rest of the 200 cells

Enjoy my profile, It is the VBAXLMan here

2009-01-26 11:48:01 by tennacious_c

Klee Klump N Kerney with Lil Ernie Colon Groove


Klee Irwin from Dual action Cleanse informercial, vs the Klumps at dinner, with a cameo by Pastor Kerney Thomas and alot of laughs from little ...


  • Buy Cheap

    • This Wednesday, you will believe a boy can lie | Robot 6 @ Comic ...

    Chris Mautner's pick of the week: Red Snow HC

    Attention Gekiga fans! Drawn and Quarterly knows how to slake your thirst for mature, literary manga with the release of this collection of short stories by Susumu Katsumata. Set in a pre-modern, rural Japan, the stories focus on the relationships between men and women, both young and old, in an agrarian culture where gender roles are strictly enforced. And if I've now made this book sound like a snoozefest, let me add that Katsumata is a natural-born cartoonist, with a charming round-headed style and never once comes off as didactic or forced, but instead is graceful and funny as well as touching. I'm not the only one who feels this way. This won the 2006 Japanese Cartoonists Association's Grand Prize Award. And they're no dummies. (Drawn and Quarterly)

    ...

    Read more...

    News

    River of ideas flows at Stafford symposium

    Houston Chronicle - Oct 16, 2009

    More bacteria live inside one-half inch of your colon than all the human beings that have ever been born. People older than 27 worry about losing their and more »
    Ed. School Dean Passes Away

    Harvard Crimson - Oct 27, 2009

    Theodore R. Sizer, former dean of the Harvard Graduate School of Education and innovative educational reformer, died last week of colon and more »
    Herman Mills, 1924-2009: Professional boxer, trained Chicago area fighters for ...

    Chicago Tribune - Oct 16, 2009

    Mr. Mills, 85, died of colon cancer Friday, Oct. 9, in Jesse Brown VA Medical Center, said Mike Joyce, who runs the boxing program at Leo High School.
    Twins Tweaked: 106 Down, 8 to Go!

    Subway Squawkers (blog) - Oct 13, 2009

    October 12, 1492: Christoffa Corombo – as he was known in his native Genoa, or Christophorus Columbus as he was known in Latin, or Cristobal Colon as his and more »
    THIS DAY IN HISTORY: BRET HART SIGNS A 20-YEAR CONTRACT WITH THE WWF, ALL ...

    Pro Wrestling Insider - Oct 20, 2009

    1974 - Ernie Ladd defeats Carlos Colon in San Juan, Puerto Rico for the WWC North American Heavyweight Title. 1976 - Akihisa Takachiho & Samson Kutsuwada and more »
    Family facing eviction

    Appeal-Democrat - Oct 05, 2009

    But when she was diagnosed with colon cancer in 2003, everything changed. Doctor's bills piled up. Maintenance and repairs to the house had to be put on
    World Match Play Championship reúne 16 golfistas da elite mundial na Espanha

    UOL Esporte - Oct 28, 2009

    A competição aconteceu pela primeira vez em 1964 e os seus maiores vencedores são o sul-africano Ernie Els, por sete vezes (1994, 1995, 1996, 2002,