breaking up people's first names
Posted by rw on December 28, 2001 5:51 AM
How can I make First names like Mary Ann, Lisa Beth be separated such that if Mary Ann was in A1, Mary would be in B1 and Ann is C1, If Lisa Beth was in A2, Lisa would be in b2, Beth in C2. Essentially cut the name after the first space, and put the rest in the following cell (column c). PLEASE HELP...urgent Please send formula to email above.
Posted by Scott on December 28, 2001 6:12 AM
The best way to do this would be Data-Text to Columns, then select Delimited, and then check the space box. Just make sure that the next column or columns are available for your data to go into.
Posted by IML on December 28, 2001 6:14 AM
Option one would be to highlight the column and select text to columns from the data menu. Hit Next and select "space" as the delimiter. Finally hit finish.
By formula you could use for first name
=LEFT(A1,FIND(" ",A1)-1)
and second name
=RIGHT(A1,LEN(A1)-FIND(" ",A1))
good luck
