How to extract the Number from a String

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

Hi John

Assuming your data always has a space after the last numeric value, and with
the data in A1
=--LEFT(A1,FIND(" ",A1)-1)

Regards

Roger Govier


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

Hi roger

thanks

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