Extract a number from a 'mixed' cell

  • Thread starter Thread starter Brickcounter
  • Start date Start date
B

Brickcounter

xl97: I'm downloading a web page into a worksheet, and I get mixed
number and text in a single cell. eg 76.3p.
Is there a formula or function that will extract the number, so that I
can use it in further calcs?
 
Hi Brickcounter!

We need a bit more in terms of examples to be definitive.

If all are with a single letter on the right, you can use

=--LEFT(A1,LEN(A1)-1)

The -- converts the text return of LEFT to numeric


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Norman,
All are as my example, and your formula works fine.
Thanks.
 
The other option of course is to use Edit / Replace and get rid of all the ps.
Then if for any reason the data is not numeric, copy an empty cell, select all
your data and do Edit / Paste Special / Add.
 
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

Extracting Numerals From a Text String? 1
How copy a cell with mixed text (regular, bold, italic) with a fo. 1
how to extract numbers from imported cell with text and numbers? 3
data from multiple files: best way to extract 1
Extracting a number from a mixed cell 15
how do I extract only certain data from a cell? 6
Extracting numbers and letters in a single cell to separate cells 1
problem with fractions to decimal 1

Back
Top