If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
spliting words up
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? |
#3
|
|||
|
|||
spliting words up
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? |
#4
|
|||
|
|||
spliting words up
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? |
Thread Tools | |
Display Modes | |
|
|