The opposite of concatenation?

  • Thread starter Thread starter Celest
  • Start date Start date
C

Celest

I have whole names that were entered into one cell, and
need to separate them into first and last names each in
their own column.

I tried to use the LEFT and RIGHT functions, but can't
figure out how to tell Excel to return everything to the
left or right of the space rather than simply a specific
number of characters.

Anyone have any ideas?

Thanks in advance.
 
Try the Data/Text to Columns menu item. Choose delimited, and check the
Space checkbox on the second pane of the wizard.
 
Hi Celest
one way:
- select your column
- goto 'Data - Text to Columns'
- choose the 'space' as delimiter

another way (if your data cosists only of twon sub strings):
=LEFT(A1,FIND(" ",A1)-1)
for the first part and
=MID(A1,FIND(" ",A1)+1,255)
for the second part
 
Back
Top