Separating data from one cell

[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?

 

[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)

 

[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


.