Thanks you for the quick response, Bob.

Thank you very much.

"Bob Phillips" wrote:

Try

=SUBSTITUTE(A1,CHAR(160),"")

--
__________________________________
HTH

Bob

"Francis Ang" wrote in message
...
I am trying to extract only the valid values from a cell and remove all the
invalid values, like ? / # etc. For example, in cell A1, the value is
?8930??/?. The length of the value is variable and the placement of the
invalid values are not fixed.

How do I extract only 8930?

I have tried, TRIM, LTRIM, RTRIM functions but it does not work!

Any help would be greatly appreciated.