Topic: | Excel - removing words at start of cell - replace can't do it | |
Posted by: | George Turner | |
Date/Time: | 18/03/15 13:31:00 |
Hello all Excel VBA experts I have monster task to remove one of two words at the start of one particular column (thousands of rows) - some rows have neither word but others have one word or the other. Each cell can have hundreds of characters in it so Replace can't handle it in my Excel 2003. For example just remove the words Peanuts or Butternut:- 1. Peanuts then other words in the cell that need to be kept..... 2. Nothing to remove in this line at all .... 3. Butternut then other words in the cell that need to be kept.... 4. and so on Any help gratefully received. |