| Topic: | Re:Excel - removing words at start of cell - replace can't do it | |
| Posted by: | Peter Grist | |
| Date/Time: | 18/03/15 18:50:00 |
| I'm surprised that Replace doesn't work. Why not use basic Excel formula to edit the text. Assuming text is in A1, A2 etc In adjacents columns do something like this. In C1 =LEN(A1) In D1 =LEFT(A1,7) In E1 =IF(D1="Peanuts",MID(A1,9,C1-7),A1) Select and drag C1..E1 for all of the rows, and then Copy and Paste values the results in Column E, back over the original text in Column A. Then do again, In D1 =LEFT(A1,9) In E1 =IF(D1="Butternut",MID(A1,11,C1-9),A1) There may be a quicker way, but I think this would do the job. |