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