View Full Version : Macro to delete trailing X's
Howardc
03-28-2013, 11:26 PM
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
03-29-2013, 12:23 AM
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
03-29-2013, 12:43 PM
Hi Rick
Thanks for the help. Your tip works perfectly
Regards
Howard
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.