spliting words up

  • Thread starter Continental Translations
  • Start date
C

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?
 
C

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
 
R

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.
 
Top