How to extract the Number from a String

J

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
 
R

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
 
Top