text to columns

  • Thread starter Thread starter gls858
  • Start date Start date
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
 
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
 
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
 
Back
Top