Use of multiple-character delimiters under Text To Columns
 

Hey everyone,

I have data in the form of several rows, each of which has several words
separated by ": " (colon + space)

I would like each word separated in its own column, and have therefore used
the Text To Columns command (under Data|Data Tools). But apparently you can
only define one character as the delimiter, and if I define it to be just the
colon, then I have a space at the beginning of each word. I know I can
probably do a few extra steps to ge rid of that leading space, but my
question is: can one define more than one character as a delimiter, under the
Text To Columns command?

Anticipated thanks for any help!

Use of multiple-character delimiters under Text To Columns
 

Put a check mark in the Space option; also put a second check mark in the
Other option and type a colon in its edit field.

--
Rick (MVP - Excel)


"wildetudor" wrote in message
...
Hey everyone,

I have data in the form of several rows, each of which has several words
separated by ": " (colon + space)

I would like each word separated in its own column, and have therefore
used
the Text To Columns command (under Data|Data Tools). But apparently you
can
only define one character as the delimiter, and if I define it to be just
the
colon, then I have a space at the beginning of each word. I know I can
probably do a few extra steps to ge rid of that leading space, but my
question is: can one define more than one character as a delimiter, under
the
Text To Columns command?

Anticipated thanks for any help!

Use of multiple-character delimiters under Text To Columns
 

You'll probably also need to check "Treat consequitive delimiters as one".
Not certain about that as I haven't tried it, but looks that way to me.

"Rick Rothstein" wrote:

Put a check mark in the Space option; also put a second check mark in the
Other option and type a colon in its edit field.

--
Rick (MVP - Excel)


"wildetudor" wrote in message
...
Hey everyone,

I have data in the form of several rows, each of which has several words
separated by ": " (colon + space)

I would like each word separated in its own column, and have therefore
used
the Text To Columns command (under Data|Data Tools). But apparently you
can
only define one character as the delimiter, and if I define it to be just
the
colon, then I have a space at the beginning of each word. I know I can
probably do a few extra steps to ge rid of that leading space, but my
question is: can one define more than one character as a delimiter, under
the
Text To Columns command?

Anticipated thanks for any help!

Use of multiple-character delimiters under Text To Columns
 

This worked, thanks!

"Rick Rothstein" wrote:

Put a check mark in the Space option; also put a second check mark in the
Other option and type a colon in its edit field.

--
Rick (MVP - Excel)


"wildetudor" wrote in message
...
Hey everyone,

I have data in the form of several rows, each of which has several words
separated by ": " (colon + space)

I would like each word separated in its own column, and have therefore
used
the Text To Columns command (under Data|Data Tools). But apparently you
can
only define one character as the delimiter, and if I define it to be just
the
colon, then I have a space at the beginning of each word. I know I can
probably do a few extra steps to ge rid of that leading space, but my
question is: can one define more than one character as a delimiter, under
the
Text To Columns command?

Anticipated thanks for any help!