Topic: | Re:Excel - removing words at start of cell - replace can't do it | |
Posted by: | Will Watson | |
Date/Time: | 18/03/15 14:33:00 |
Just stick this formula in the adjacent column: =IF(LEFT(A2,7)="Peanuts",MID(A2,8,999),IF(LEFT(A2,9)="Butternut",MID(A2,10,999),A2)) |