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.