This is great. And yes I would like to know how you would separate a fields
(each space) for the following example, "abc klmnop xyz 123 456 789"?


=MID(A1,FIND(" ",A1)+1,256)
Can I assume 256 from the formula above is for 256 characters?

I'm also using Excel 2007 if that matters.

Thanks again.

Mr BT
"Bernard Liengme" wrote in message
...
Your sue of the word "script" suggests you want a VBA solution.
But here are some non-VBA pointers:
1) are you aware of the feature Data }Text to Columns ?
2) If A1 has the value "abc xyz" (without quotes) then
=LEFT(A1,FIND(" ",A1)-1) will return "abc" and =MID(A1,FIND(" ",A1)+1,256)
will return "xyz"
What to want to happen with "abc klmnop xyz"? Do you want three separate
parts, or two?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Mr BT" wrote in message
news:D_uQi.46902$Da.12890@pd7urf1no...
How can I run a text to column on the first space in the cell? I also
want to run this script with directions to separate on the second space
rather than the first.
Thank you for the help

Mr BT