Topic: | Re:Excel - removing words at start of cell - replace can't do it | |
Posted by: | Dan Murphy | |
Date/Time: | 18/03/15 13:40:00 |
George I would sort the relevant column so that you have blocks of rows containing either one or other of the target words, or neither. Then, selecting each block in turn you can parse the cells into separate cells by splitting them in two, based on the characters in the leading word you want to delete. So for the first block of cells, you then have two adjacent cells the first containing the word Peanuts (7 chs) and the second containing everything else The parse the next block of cells containing the word Butternut, separating out the first 9 Chs and creating two adjacent cells. The third block needs nothing doing, just creating two adjacent cells the first containing nothing, and the second containing a straight copy. then select the first new column, containing the target words, and hit delete. That ought to do it. |