Extracting an Integer

[Ed]

Hi

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

Thx

 

[Chip Pearson]

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

 

[Andy B]

Ed

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

Andy.

 

[Peo Sjoblom]

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