Extracting an Integer

  • Thread starter Thread starter Ed
  • Start date Start date
E

Ed

Hi

What function would i use to extract a number from a cell
with text and numbers combined in it?

Thx
 
Ed,

The specific formula would depend on the actual contents of the
cell, but in general it would be a combination of LEFT, RIGHT,
MID, and possibly FIND.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Ed

Have a look at using VALUE() and MID(), LEFT() or RIGHT() depending on where
the letters are.

Andy.
 
If the numeric are contiguous

=--MID(A1,MATCH(FALSE,ISERROR(--MID(A1,ROW(INDIRECT("1:100")),1)),0),100-SUM
(--ISERROR(--MID(A1,ROW(INDIRECT("1:100")),1))))

entered with ctrl + shift & enter, if not you would need VBA
 
Back
Top