Topic: | Re:Re:Re:Re:Re:Re:Re:Re:Excel - removing words at start of cell - replace can't do it | |
Posted by: | Matteo Castagna | |
Date/Time: | 18/03/15 16:53:00 |
Oh well, I didn't see that requirement but if this is the case just replace the relevant two lines with ActiveCell.Value = Replace(ActiveCell.Value, "Peanuts ", "", 1) ActiveCell.Value = Replace(ActiveCell.Value, "Butternut ", "", 1) And will replace those instances of Peanuts and Butternut (I added a space just to avoid an end string that starts with a space) that happen to start at the beginning of the original string. |