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.
I don't think there is any built in functionality that will remove those other code from those cells.