Removing Non-Numeric Characters

I have a list of numbers which contain both numbers & text characters. (Eg: 123/456/7).

I need to match this list to another one which contains only numbers. (Eg: 1234567).

Is there a formula I can use which allows me to extract only numerical characters from a cell.

Many Thanks

Glen

Find & Replace works for most of the characters except for a character which appear at the front of some of the numbers (EG: '354859). I've tried copying & pasting this character into the Find & Replace but it doesn't work.

I think it's something that's been entered to force Excel to start numbers with a 0.

Glen

Thanks again - worked fine.

Glen

Use
=SUBSTITUTE(A1,"/","")
instead of A1 if A1 contains 123/456/7

Stefi

"GlenS" wrote:

>
> I have a list of numbers which contain both numbers & text characters.
> (Eg: 123/456/7).
>
> I need to match this list to another one which contains only numbers.
> (Eg: 1234567).
>
> Is there a formula I can use which allows me to extract only numerical
> characters from a cell.
>
> Many Thanks
>
> Glen
>
>
> --
> GlenS
> ------------------------------------------------------------------------
> GlenS's Profile: http://www.excelforum.com/member.php...o&userid=28028
> View this thread: http://www.excelforum.com/showthread...hreadid=475327
>
>