I have a spreadsheet where I would like to delete all numbers where there is a trailing X in Column A on "imported Data" for eg 6X, 905X, 1111X etc

Your assistance in this regard is most appreciated