Download and install the free add-in Morefunc.xll from:
http://xcell05.free.fr/
....then use this formula

=REGEX.SUBSTITUTE(A1,"\D+")


"dk" wrote:

I am trying to find all number entries that contain any character other then
0-9 and
replace the cell and remove everthing from those cells