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.
You already have what you require from SergeiBaklan​ but, as an alternative, for better or worse, I tend to leave source data unaltered. A 365 formula that filters out records with codes other than FC or FT might be
= FILTER(table, REGEXTEST(codes, "\b(FC|FT)\b"))where 'table' and 'codes' are defined names.
=REGEXEXTRACT(codes, "\b(FC|FT)\b")
