How do I split a cell of 2 words into two cells

[Guest]

I have a field called Contact that has First Name and Last Name. I would
like to split this into 2 cells, one for First Name and one for Last Name.
How do I do this? Thank you for your help.

Sincerely,
Steven S

 

[KL]

menu Data>Text to Columns..., on screen 1: choose the option 'Delimited', on
screen 2 choose delimiter: 'space', etc.

Regards,
KL

 

[Guest]

one way:
See text to columns use the space as the delimiter
HTH

 

[Guest]

If you name is in cell A1:

In B1: =LEFT(A1,FIND(" ",A1)-1)

In C1: =RIGHT(A1,LEN(A1)-FIND(" ",A1))

This assumes that the name in A1 is formatted like this: FName(space)LName.

 

[Ron Rosenfeld]

I have a field called Contact that has First Name and Last Name. I would
like to split this into 2 cells, one for First Name and one for Last Name.
How do I do this? Thank you for your help.

Sincerely,
Steven S

Data/Text to Columns. Select Delimited and Space>


--ron