Split 2 words in one cell to two cells

[BradGlab]

Version: 2004 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Can i turn one cell that has 2 words in it to 2 new seprate cells. i.e
A1
Happy Birthday

I would like B1 to be happy and C1 to be birthday

thnaks

Brad

 

[macropod]

Hi Brad,

Assuming you want to keep whatever's in A1 where it is, try:
=LEFT(A1,FIND(" ",A1)-1)
=RIGHT(A1,LEN(A1)-FIND(" ",A1))

 

[BradGlab]

Worked!! Thank you so much!!!

 

[CyberTaz]

Just in case it comes up again, here's another option that doesn't rely on
keeping the content in Column A. it also gives you text content in the
resulting cells rather than formulas displaying text as their result:

Select the cell/s then go to Data> Text to Columns, select the appropriate
separator in the Wizard's second step.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[macropod]

Hi Bob,

I concluded that the OP wanted to keep the original data in Column A, since the parsed output is required in Columns B & C. To get
that with your method, you'd need to move the data one column to the right, whether before or after the split.

--
Cheers
macropod
[Microsoft MVP - Word]

 

[CyberTaz]

No question... I was just going on the assumption that most users really
neither wan nor need the redundant data even though the phrasing of the
question suggested otherwise. It's surprising how the manner in which a
question is asked can pivot around awareness of what options may exist

Regards |:>)
Bob Jones
[MVP] Office:Mac