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?
Social Networking Bookmarks