Excel Formula: split cell by spaces

[Budza]

Need to split cell contents by spaces:

|one two three| (1cell)

becomes:

|one|two|three| (3cells)

Google isn't doing it for me today

 

[Jab]

Assuming text in A1

First word:
=LEFT(A1,FIND(" ",A1,1)-1)

Second word:
=MID(A1,FIND(" ",A1,1)+1,FIND(" ",A1,FIND(" ",A1,1))-1)

Third word:
=RIGHT(A1,LEN(A1)-FIND(" ",A1,FIND(" ",A1,1)+1))

 

[ebendl]

Or use the data to columns function (if you only want to do it once-off)

http://www.techrepublic.com/blog/ms...-command-to-separate-first-and-last-names/866


(You are using Excel 2007 / 2010, I presume?)

 

[Budza]

Awesome. Exactly what I needed.
Thanks.