You can use Find and Replace to replace two spaces by a special character (^?) and use that as a delimiter in Text to Columns

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"J@Y" wrote in message ...
| 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.