Is there a function in Excel that will allow me to only capture the numbers in a string? Below is a list and I would like to in a seperate column only capture the numbers in each of the below strings. I can't seem to figure out how to get rid of the *



HB 8185******
HB 8214******
HB 8216
HB 8217******
HB 8220******