On Wed, 23 Aug 2006 11:48:02 -0700, Elbrian
wrote:
I'm trying to do a FIND-REPLACE on a list of alpha-numeric figures. I want
to eliminate just the numbers. For instance, I want to REPLACE "45DOR143"
with "DOR". Trouble is when I do a FIND for "*DOR*" I also FIND "DORMANT"
and other cells which I don't want to replace and have to manually change
those words so they don't trigger the search. (I make the search case
sensitive and make a letter in the cell I don't want lower case).
Anyway, is there a wildcard which will look only for numbers?
No there is not.
One way to do this using formulas is to download and install Longre's free
morefunc.xll add-in from
http://xcell05.free.fr
Then use the formula:
=REGEX.SUBSTITUTE(A1,"\d")
--ron