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

S

Steven S

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
 
K

KL

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

Regards,
KL
 
D

David Hepner

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

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
Click to expand...

Data/Text to Columns. Select Delimited and Space>


--ron
 
Top