First, thanks to all who help me out. OK, here's the problem.
I have a worksheet of names, addresses, and other info. A person's name is in the following format in a single cell A1:
_][___A______]
1][Doe, John Q.]
I want this name to be divided into three seperate cells to read
_][__A__][_B_][_C_]
1][ John ][ Q. ][ Doe ]
I should also mention that not all the names include all parts and say just:
_][___A____]
1][Doe, John]
or
_][_A_]
1][Doe]
I already saw the functions that "extract" the first, middle and last names. But, they require the original cell to remain. I need a function that will do what I would have to do for days using cut and paste to truly divide the data into 3 columns, not just return its value in three columns. Are there any options here? If functions won't do it, what other choices have I?
Bookmarks