Column to Text Question - Stop after one break

S

Sole Admiral

I am stuck on a text -> Column issue. This feature is wonderful and ha
saved me hours of work, but i was wondering if there was a way to jus
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
column for the word "Julia" another column for "Goolia", yet anothe
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 woul
have the remaining "Goolia, II, Esq."

Is this a possibility or have i reached yet a limit to this wonderfu
software
 
E

Erin

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.
 
Top