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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top