Remove all non-numeric characters from selection EXCEPT "x".

Hi All,

I need code to remove all non-numeric characters from a selection, except for a lowercase "x". Can you helP/

I have the range selection:

Dim X1, X2, X3, MultiRange As Range
Set X1 = Range("AD:AD" & Lastrow)
Set X2 = Range("AE:AE" & Lastrow)
Set X3 = Range("AF:AF" & Lastrow)

Set MultiRange = Union(X1, X2, X3)
MultiRange.Select

but now I'm stuck. Thank you!

Remove all non-numeric characters from selection EXCEPT "x".

Please Login or Register  to view this content.

Thank you! Worked perfectly!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.