The opposite of concatenation?

[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.

 

[JE McGimpsey]

Try the Data/Text to Columns menu item. Choose delimited, and check the
Space checkbox on the second pane of the wizard.

 

[Frank Kabel]

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