Delimit using 2 spaces instead of 1?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

| 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.
 
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.
 
That's a brilliant, thanks guys!

Tom Ogilvy said:
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.
Click to expand...
 
Back
Top