Excel - How To Search For A Number In a Cell Containing Several Numbers

J

John

Excel - How To Search For A Number In a Cell Containing
Several Numbers?

I'm trying to determine how to search for a specific
number in a cell whaich contains several digits. So, if
cell d1, c1, e1 number 7584951. If i wanted to create a
formula to indentfy just the numbers 758 in this cell how
can it be done.

Thanks!
 
D

Dave R.

For D1;

=--ISNUMBER(FIND(758,D1))

remove the "--" if you want only a TRUE/FALSE response.
 
Top