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" <(E-Mail Removed)> wrote in message news:08987666-08B8-4106-84B5-(E-Mail Removed)...
| 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.