Thread: text to columns
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
gls858 gls858 is offline
external usenet poster
 
Posts: 209
Default 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