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
well assuming FT and FC are the only 'F' codes you could just use *F
the only other caveot is that if you have FT and FC in the same cell this method will remove one of them (the one that is not last) and will not show that both were there
the only other caveot is that if you have FT and FC in the same cell this method will remove one of them (the one that is not last) and will not show that both were there