text to columns

[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

 

[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

 

[gls858]

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

Thanks Bill that did the trick.

gls858