John,
The text to columns worked perfectly to separate it all out (it's 0010), except for those Mr. & Mrs. John Jacob Ryan III's.... I guess there's nothing I can do about that but concatenate them back together?
I have a mailing list that is three lines over one another ina single cell in excel, ex:
Mr. John Doe
123 Street St
City, State ZIP
I need to break this information down completely so that the title, first name, last name, street, city, state, zip all go in to different cells..
Mr. | John |...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.