ASAP Utilities, a free Add-in available at www.asap-utilities.com has a
feature that will delete all numbers from a string wherever they are
located...........

Vaya con Dios,
Chuck, CABGx3


"johnbest" wrote:

>
> 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
>
>