Separating data from one cell

  • Thread starter Thread starter joey041
  • Start date Start date
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?
 
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)
 
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...
 
Back
Top