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

S

SSSundhar

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


w8 for the result
by
sundar
 
R

reitanospa1

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.
 
G

Gord Dibben

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
 

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

Count Number of Unique Cells That Don't Have Certain Characters 0
How to count the numbers in a Word document? 0
Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
Problem with MS Word paragraph and character styles: format getting messed up 2
using an IF or AND function to get next largest value in list 1
Identifying common data between 2 cells 1
Hightlight cells that contain special characters 13
Find text in cell and copy from 4 characters in front of the found text. 2

Top