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

  • Thread starter Thread starter John
  • Start date Start date
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!
 
For D1;

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

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