How to extract the Number from a String

[johnbest]

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

 

[Roger Govier]

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]

Hi roger

thanks

 

[Guest]

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