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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how to find number in a cell , a cell contains character data ornumeric data (https://www.excelbanter.com/excel-worksheet-functions/177171-how-find-number-cell-cell-contains-character-data-ornumeric-data.html)

[email protected]

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

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

w8 for the result
by
sundar

[email protected]

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

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.

On Feb 19, 12:15 pm, wrote:
i'm sundar if any body know this solution. plz help me

w8 for the result
by
sundar

Mike H

how to find number in a cell , a cell contains character data or n

Hii,

=ISTEXT(A1)
=ISNUMBER(A1)

Mike

" wrote:

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

w8 for the result
by
sundar

Gord Dibben

how to find number in a cell , a cell contains character data or numeric data

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

On Tue, 19 Feb 2008 09:15:20 -0800 (PST), wrote:

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

w8 for the result
by
sundar

All times are GMT +1. The time now is 03:26 PM.