Macro to delete trailing X's

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

Quote:

---

Originally Posted by 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

---

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.

Hi Rick

Thanks for the help. Your tip works perfectly

Regards

Howard