Hello friends

I have a column with following type of data:
1243 no. of Books
213 no. of Pens

What i want is to extract only the numeric data from the column and
keeping the the original string as it is

thanks in advance
johnbest


--
johnbest
------------------------------------------------------------------------
johnbest's Profile: http://www.excelforum.com/member.php...o&userid=29694
View this thread: http://www.excelforum.com/showthread...hreadid=494535