Column to Text Question - Stop after one break

I am stuck on a text - Column issue. This feature is wonderful and has
saved me hours of work, but i was wondering if there was a way to just
seperate the text in a column only once.

For Example:

Julia Goolia, II, Esq.

In text - Columns, if breaking at the (space), that data would make a
column for the word "Julia" another column for "Goolia", yet another
for "II", and finally a column for "Esq."

What I want to do is have Text - Columns stop after the first (Space)
so that the first column would be "Julia" and the second column would
have the remaining "Goolia, II, Esq."

Is this a possibility or have i reached yet a limit to this wonderful
software?


---
Message posted from http://www.ExcelForum.com/

You may want to consider using formulas so that if Julia
Goolia, II, Esq. is in cell A2, B2 would hold the formula
=LEFT(A2,FIND(" ",A2)-1) while C2 would hold the formula
=RIGHT(A2,LEN(A2)-(LEN(B2)+1)).

The formula in column B FINDs the position of the first
space and returns a string representing the portion of the
original string starting from the left and ending one
position before the space. The formula in column C returns
the next portion (on the right) starting one position
after the space.

-----Original Message-----
I am stuck on a text - Column issue. This feature is
wonderful and has
saved me hours of work, but i was wondering if there was
a way to just
seperate the text in a column only once.

For Example:

Julia Goolia, II, Esq.

In text - Columns, if breaking at the (space), that data
would make a
column for the word "Julia" another column for "Goolia",
yet another
for "II", and finally a column for "Esq."

What I want to do is have Text - Columns stop after the
first (Space)
so that the first column would be "Julia" and the second
column would
have the remaining "Goolia, II, Esq."

Is this a possibility or have i reached yet a limit to
this wonderful
software?


---
Message posted from http://www.ExcelForum.com/

.