If the numbers are always together in the string, you
could use this formula (array-entered)

=MID(A1,MATCH(TRUE,bre,0),MATCH(TRUE,bre)-MATCH
(TRUE,bre,0)+1)

where bre is a defined name for:

=ISNUMBER(1*MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))

If not, Gord Dibben posted a robutst macro solution:

http://tinyurl.com/5p5ms

HTH
Jason
Atlanta, GA

-----Original Message-----
Is there function that will look at the value of a cell
and ignore the text
but return the numeric value only.

Example: cell value is CH123XX
Retrun value : 123

Amount of text would be dynamic.

Thnanks





.