spliting words up

In cells A1:A502, I have a few words in each cell. These words are split up
by a colon. So, for example, in cell A1, it says "Today : yesterday", cell
A2, "Once : went" etc.... There is no particular relevancy between the two
words.

Now what I want is for all the words which come after the colons, so in the
above case, 'yesterday' and 'went' to be moved from column A into column B.

Any ideas?

datatext to columnsdelimited

--
Don Guillett
SalesAid Software

"Continental Translations" wrote in message
...
In cells A1:A502, I have a few words in each cell. These words are split
up
by a colon. So, for example, in cell A1, it says "Today : yesterday", cell
A2, "Once : went" etc.... There is no particular relevancy between the two
words.

Now what I want is for all the words which come after the colons, so in
the
above case, 'yesterday' and 'went' to be moved from column A into column
B.

Any ideas?

Highlight column A
Data Text to columns delimited Next
Check the "Other" box and enter the colon in the box following "Other"
Finish

Note, that if you actually had spaces surrounding the colon, this will
leave leading spaces on your words in Column B.........you can eliminate
them with the =TRIM(B1) function..............

Vaya con Dios,
Chuck, CABGx3




"Continental Translations" wrote in message
...
In cells A1:A502, I have a few words in each cell. These words are split
up
by a colon. So, for example, in cell A1, it says "Today : yesterday", cell
A2, "Once : went" etc.... There is no particular relevancy between the two
words.

Now what I want is for all the words which come after the colons, so in
the
above case, 'yesterday' and 'went' to be moved from column A into column
B.

Any ideas?

You can choose *more* then one delimiter at a time!

So, if you click "space" *and* add the colon ( after "Other", the
resulting separated data will not have any spaces.

You should also make sure that "Treat Consecutive Delimiters As One" is
checked, though it usually is by default.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"CLR" wrote in message
...
Highlight column A
Data Text to columns delimited Next
Check the "Other" box and enter the colon in the box following "Other"
Finish

Note, that if you actually had spaces surrounding the colon, this will
leave leading spaces on your words in Column B.........you can eliminate
them with the =TRIM(B1) function..............

Vaya con Dios,
Chuck, CABGx3




"Continental Translations" wrote in
message
...
In cells A1:A502, I have a few words in each cell. These words are split
up
by a colon. So, for example, in cell A1, it says "Today : yesterday",
cell
A2, "Once : went" etc.... There is no particular relevancy between the
two
words.

Now what I want is for all the words which come after the colons, so in
the
above case, 'yesterday' and 'went' to be moved from column A into column
B.

Any ideas?