| Topic: | Re:Excel - removing words at start of cell - replace can't do it | |
| Posted by: | Matteo Castagna | |
| Date/Time: | 18/03/15 15:12:00 |
| Let me try to suggest a more scalable solution for your problem. 1. Let's say you have more than the two words you need to get rid of. Place all the words in a column and call that column (Define Name) "GetRidOf" as an example. This way the number of string can be anything. 2. The relevant formula that manages to get rid of all the instances of the GetRidOf names you defined, is: =SUBSTITUTE(A1,LOOKUP(10^10,FIND(GetRidOf,A1),GetRidOf),"") This basically search for any instance of any entry in GetRidOf in the A1 cell (I am assuming the original text is staked in column A). THIS FORMULA WILL RETURN #N/A WHEN THERE IS NOTHING TO REPLACE That means you need to place an error check (ISNA()) around it. |