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.

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.

In text to columns,
you do have a check box that says to treat consecutive delimiters as one.

--
Regards,
Tom Ogilvy



"J@Y" wrote:

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.

Sorry, I was focused on the expanse between the two sections and
misinterpreted what you were asking. You could do an Edit=Replace on the
column and replace 2 or perhaps 3 spaces with a semi colon or something like
that. then do text to columns.

--
Regards,
Tom Ogilvy


"J@Y" wrote:

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.

That's a brilliant, thanks guys!

"Tom Ogilvy" wrote:

Sorry, I was focused on the expanse between the two sections and
misinterpreted what you were asking. You could do an Edit=Replace on the
column and replace 2 or perhaps 3 spaces with a semi colon or something like
that. then do text to columns.

--
Regards,
Tom Ogilvy


"J@Y" wrote:

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.