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)) |

Entire Thread |