how to find number in a cell , a cell contains character data ornumeric data

  • Thread starter Thread starter SSSundhar
  • Start date Start date
I'm not absolutely sure on your question.
Are you trying to find if a cell contains numeric data? If so, there
is a function called ISNUMBER that will give you a true or false.
Are you trying to find text within a cell? If so, there is a function
called FIND that reports the position of a string within a cell.
 
Post your question in the body of the message, not in the subject line which
gets cut off.

Maybe =ISNUMBER(A1)


Gord Dibben MS Excel MVP
 
Back
Top