Separating data from one cell

J

joey041

If I have two words in one cell, how can I separate them
to appear in two cells. I know that concatenate will
group them together but is there a function to break them
apart?
 
F

Frank Kabel

Hi
see: Data - Text to columns'

For a formula solution use (for two words):
=LEFT(A1,FIND(" ",A1)-1)

and
=MID(A1,FIND(" ",A1)+1,255)
 
G

Guest

Thanks!
-----Original Message-----
Hi
see: Data - Text to columns'

For a formula solution use (for two words):
=LEFT(A1,FIND(" ",A1)-1)

and
=MID(A1,FIND(" ",A1)+1,255)


--
Regards
Frank Kabel
Frankfurt, Germany


.
Click to expand...
 
Top