Originally Posted by

**pattikins**
So long as the non-numerical values are grouped together, the following formula should work irrespective of where or how many non-numerical characters appear in the string.

=VALUE(SUBSTITUTE(A1,TRIM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"0",""),"1",""),"2",""),"3",""),"4",""),"5",""),"6",""),"7",""),"8",""),"9","")),""))

Is the "g" in the sample of any significance? Have you tried searching for a macro to do the same job?