| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a way to find out whether theres a number in a cell??
Hi,
Is there a worksheet function that could help finding out whether theres a number in a cell, within a string etc?? Thanks. Elaine. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there a way to find out whether theres a number in a cell??
check "is functions" in help
there are isnumber(),istext() etc. " wrote: Hi, Is there a worksheet function that could help finding out whether theres a number in a cell, within a string etc?? Thanks. Elaine. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there a way to find out whether theres a number in a cell??
how about if my cell contains apple123?? it doesnt seem that the
isnumber(), istext() function work.... |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there a way to find out whether theres a number in a cell??
Hi Elaine
Try =SUMPRODUCT(--(ISNUMBER(FIND({0,1,2,3,4,5,6,7,8,9},A1))))0 -- Regards Roger Govier wrote in message oups.com... how about if my cell contains apple123?? it doesnt seem that the isnumber(), istext() function work.... |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there a way to find out whether theres a number in a cell??
with
A1 containing a number, alphanumeric, text, or blank Try this: =MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789") )<=LEN(A1) That formula returns TRUE if there are any numbers in A1's value Does that help? *********** Regards, Ron XL2002, WinXP " wrote: how about if my cell contains apple123?? it doesnt seem that the isnumber(), istext() function work.... |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there a way to find out whether theres a number in a cell??
Here's a shorter alternative to the formula I posted
=SUM(--ISNUMBER(SEARCH({0,1,2,3,4,5,6,7,8,9},A1)))0 Does that help? *********** Regards, Ron XL2002, WinXP "Ron Coderre" wrote: with A1 containing a number, alphanumeric, text, or blank Try this: =MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789") )<=LEN(A1) That formula returns TRUE if there are any numbers in A1's value Does that help? *********** Regards, Ron XL2002, WinXP " wrote: how about if my cell contains apple123?? it doesnt seem that the isnumber(), istext() function work.... |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there a way to find out whether theres a number in a cell??
Using a helper column with the entire column copied over to it, there is a
feature in the ASAP Utilities that will delete all alpha characters, leaving only the numbers........ASAP Utilities is a free add-in available at www.asap_utilities.com Vaya con Dios, Chuck, CABGx3 " wrote: Hi, Is there a worksheet function that could help finding out whether theres a number in a cell, within a string etc?? Thanks. Elaine. |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there a way to find out whether theres a number in a cell??
Thanks guys!!
all the formulas work!! yay! Thanks again! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I find the number of letters in a cell? | Excel Discussion (Misc queries) | |||
| Find the 1st occurance of a number in a cell | Excel Worksheet Functions | |||
| Find max number of character and return cell address | Excel Worksheet Functions | |||
| find number position in excel text cell | Excel Discussion (Misc queries) | |||
| find the cell above any number in any range | Excel Worksheet Functions | |||
Hybrid Mode
