Topic: | Re:Re:Excel - removing words at start of cell - replace can't do it | |
Posted by: | George Turner | |
Date/Time: | 18/03/15 15:47:00 |
Thanks for all the replies. The complications are that Excel 2003 is out of its depth and I cannot sort a split column as all the data is arranged into significant groups and there's no way of reversing the sort afterwards. Also the amount of text within each cell varies greatly - sometimes hundreds of characters. I did try (borrowing Excel 2010) using the split cols by fixed characters then using Find/Replace within the text left in the old col and it will work but its tricky. I will next try your suggestion of:- =IF(LEFT(A2,7)="Peanuts",MID(A2,8,999),IF(LEFT(A2,9)="Butternut",MID(A2,10,999),A2)) A VBA bit of programming that goes though all the cells in the subject col looking at the start of each string would be the best option. thanks again |