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.
 
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.
 
Back
Top