View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
J@Y J@Y is offline
external usenet poster
 
Posts: 127
Default Delimit using 2 spaces instead of 1?

Say I have a lline of text:

The dog 's name is Mike.

How is it possible to separate that into two columns, split between "is" and
"Mike"? Delimiter can't be set to " than 2 spaces" for text to column.