Break apart data of one cell into two cells

[Mark]

Is there a way to break apart the data of a single cell
into two or multiple cells? What I have is a full name
field I need to separate into two cells, first and last.

What I have currently:
Cell A1=Jon Doe

What I want:
Cell B1= Jon
Cell C1= Doe

Thanks

 

[John Wilson]

Mark,

You can try using Data/Text to Columns with a space
as a delimiter.

For other methods, try here:
http://www.cpearson.com/excel/FirstLast.htm

John

 

[sherry]

Here is a copy of a formula to break it into 2 cells
do these in the 2 columns you want to put the names in.

good luck.
sherry

=LEFT(A1,FIND(" ",A1))
=IF(FIND(" ",A1 & " ") < LEN(TRIM(A1)),MID(A1,FIND(" ",A1)
+ 1,LEN(A1)),A1)

 

[SHERRY]

try this formula and save it for others.
PUT THIS FORMULA IN CELL B
=LEFT(A1,FIND(" ",A1))

PUT THIS ONE IN CELL C
=IF(FIND(" ",A1 & " ") < LEN(TRIM(A1)),MID(A1,FIND(" ",A1)
+ 1,LEN(A1)),A1)

GOOD LUCK
SHERRY