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


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

How to extract the Number from a String
 

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

How to extract the Number from a String
 

Hi roger

thanks


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

How to extract the Number from a String
 

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