Break apart data of one cell into two cells

  • Thread starter Thread starter Mark
  • Start date Start date
M

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
 
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)
 
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
 
Back
Top