Hello everyone!
I have about 4,000 names and they are all in one column, but in groups of 3's. Example...
A1: JOHN DOE HUGH JACKMAN JANE SMITH
A2: TARZAN ERNEST HEMMINGWAY SEAN CONNERY
... I'd like to separate them into three different columns but they are all different lengths with no common delimiter. Even the spaces between them aren't even. To get the names into columns E, F, and G, I used the LEFT function to get the first name. I used =MID(A1,LEN(E1),LEN(A1)-(LEN(G1)+LEN(E1))) to get the second name, but that will only work if I can figure out a way to get the third name into cell G.
Any clues??? Thanks in advance!
stinkstik
Bookmarks