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

Hi Glen

Try Edit and Replace


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=475327