Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 38
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,501
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
HOW DO I SORT DATA USING A SPECIFIC CHARACTER IN A CELL GEORGE Excel Discussion (Misc queries) 1 May 31st 07 04:42 PM
Find max number of character and return cell address ExcelMonkey Excel Worksheet Functions 5 April 15th 06 04:13 AM
Find MAX data in sheet (Cell) - Any cell that exceeds X amount of data confuzedagain Excel Discussion (Misc queries) 1 December 7th 05 06:56 PM
The match and lookup functions can find literal data but not the same data referenced from a cell Jeff Melvaine Excel Discussion (Misc queries) 3 April 30th 05 01:29 PM
identify data in a cell that has a number as the second character Brian Excel Worksheet Functions 1 December 12th 04 04:23 PM


All times are GMT +1. The time now is 09:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"