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

  • Thread starter Thread starter SSSundhar
  • Start date Start date
S

SSSundhar

i'm sundar if any body know this solution. plz help me


w8 for the result
by
sundar
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying formulas in range and pasting in a selection 3
problem while attaching a file using send to mail recipient 1
WPF Popup always topmost in z-Index 2
Conditional Formatting for Values in 3 cells 4
Incremental search to find worksheets 2
How to insert a bitmap image into a Excel Cell? 0
Dynamically Creating repeating tables with ASP and CSS 3
Making domain user a local admin 2

Back
Top