| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW DO I SORT DATA USING A SPECIFIC CHARACTER IN A CELL | Excel Discussion (Misc queries) | |||
| Find max number of character and return cell address | Excel Worksheet Functions | |||
| Find MAX data in sheet (Cell) - Any cell that exceeds X amount of data | Excel Discussion (Misc queries) | |||
| The match and lookup functions can find literal data but not the same data referenced from a cell | Excel Discussion (Misc queries) | |||
| identify data in a cell that has a number as the second character | Excel Worksheet Functions | |||
Linear Mode
