text to columns
 

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

text to columns
 

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


--
Greetings from New Zealand
"gls858" wrote in message
...
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

text to columns
 

Bill Kuunders wrote:
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