Macro to delete trailing X's

[Howardc]

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

[Rick Rothstein]

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

Assuming those numbers in Column A with the X as the last character are all that you want to delete (as opposed to other cells on the same row or even the entire row), and assuming the X can only appear on the end of the number, then try this... select Column A, press CTRL+H to bring up the Replace Dialog box, type *X (that an asterisks followed by an X) in the "Find what" field, leave the "Replace with" field empty and click the OK button.

[Howardc]

Hi Rick

Thanks for the help. Your tip works perfectly

Regards

Howard