see the 2nd formula in Peo's post here;

http://groups-beta.google.com/group/...2?dmode=source




"Grant" wrote in 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