spliting words up

[Continental Translations]

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?

 

[Don Guillett]

data>text to columns>delimited>

 

[CLR]

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

 

[Ragdyer]

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.