Oops it already exists :-)

http://www.ozgrid.com/VBA/ExtractNum.htm


On Sep 22, 4:54*pm, JP wrote:
How about a UDF that loops through the cell, uses the LIKE function to
compare each cell to [0123456789] and if there's a match, builds a
string consisting of the matching characters?

I'm sure that's the hard way.

--JP

On Sep 22, 4:45*pm, JLGWhiz wrote:



Sorry, Val only works if the string begins with a number.