text to columns

G

gls858

I have a column of text I want to split. How would I make it split on
two spaces. Example

Mt Vernon IL600111

I want Mt Vernon in one column and IL600111 in the other.

gls858
 
B

Bill Kuunders

You could do a find and replace to change the double space to a comma
and then do a <data> <text to columns> with the comma as the delimiter
 
G

gls858

Bill said:
You could do a find and replace to change the double space to a comma
and then do a <data> <text to columns> with the comma as the delimiter
Click to expand...

Thanks Bill that did the trick.

gls858
 
Top