How to extract the Number from a String

  • Thread starter Thread starter johnbest
  • Start date Start date
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
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Extract Text from decimal separated string 6
Downloading page format from net 3
Extracting a word form a text string 8
extract numbers from text string 4
extract 3 numbers from a string 0
Excel Help to copy information from one row at a time to another sheet 1
Extract numeric from text string 4
how to get min value from a column using VBA 3

Back
Top