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