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

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

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

Regards,
KL


"Steven S" wrote in message
...
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

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

"Steven S" wrote:

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

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.

"Steven S" wrote:

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

On Tue, 13 Sep 2005 07:32:13 -0700, "Steven S"
wrote:

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