Forum Discussion
Solved
removing unwanted data from a cell
I have a column with codes, the codes I need are FT and FC, but there are cells with extra codes which I want to remove and only have FT or FC appear in the cell. how do I do this without having to c...
Assuming FT and FC are always at the end, select column (or range) with codes, Ctrl+H and replace all *FT on FT. Same for FC.
worked like a charm! thanks so much
joannduplessis88 , you are welcome
Hi I actually wrote a reply now for help on this query now I can't find it