Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
determine wheter string has a number in it?
Is there an easy formula that will look at a cell and determine whether a
number 0-9 is in that cell? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
determine wheter string has a number in it?
Let me clarify -- formula looks in A1 to determine whether or not a number is
in the string that is in A1. For example A1 = asfkajsf4asdf --- TRUE A1 = asdlfksdfa ---- FALSE "Ted Metro" wrote: Is there an easy formula that will look at a cell and determine whether a number 0-9 is in that cell? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
determine wheter string has a number in it?
With
A1 containing a value that may contain a number or be blank This formula returns TRUE if A1 contains a number: =MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789") )<=LEN(A1) Is that something you can work with? *********** Regards, Ron XL2002, WinXP "Ted Metro" wrote: Let me clarify -- formula looks in A1 to determine whether or not a number is in the string that is in A1. For example A1 = asfkajsf4asdf --- TRUE A1 = asdlfksdfa ---- FALSE "Ted Metro" wrote: Is there an easy formula that will look at a cell and determine whether a number 0-9 is in that cell? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
determine wheter string has a number in it?
Try this:
=ISNUMBER(--MID(A1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"01234567 89")),1)) Biff "Ted Metro" wrote in message ... Is there an easy formula that will look at a cell and determine whether a number 0-9 is in that cell? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
determine wheter string has a number in it?
Very much so Mr. C.
Thank you much! "Ron Coderre" wrote: With A1 containing a value that may contain a number or be blank This formula returns TRUE if A1 contains a number: =MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789") )<=LEN(A1) Is that something you can work with? *********** Regards, Ron XL2002, WinXP "Ted Metro" wrote: Let me clarify -- formula looks in A1 to determine whether or not a number is in the string that is in A1. For example A1 = asfkajsf4asdf --- TRUE A1 = asdlfksdfa ---- FALSE "Ted Metro" wrote: Is there an easy formula that will look at a cell and determine whether a number 0-9 is in that cell? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
determine wheter string has a number in it?
I'm glad that worked for you.....and thanks for the feedback (much appreciated)
*********** Regards, Ron XL2002, WinXP "Ted Metro" wrote: Very much so Mr. C. Thank you much! "Ron Coderre" wrote: With A1 containing a value that may contain a number or be blank This formula returns TRUE if A1 contains a number: =MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789") )<=LEN(A1) Is that something you can work with? *********** Regards, Ron XL2002, WinXP "Ted Metro" wrote: Let me clarify -- formula looks in A1 to determine whether or not a number is in the string that is in A1. For example A1 = asfkajsf4asdf --- TRUE A1 = asdlfksdfa ---- FALSE "Ted Metro" wrote: Is there an easy formula that will look at a cell and determine whether a number 0-9 is in that cell? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting the number of instances of a string within another string | Excel Worksheet Functions | |||
How to determine the number in excel? | Excel Discussion (Misc queries) | |||
How to determine the number of units? | Excel Discussion (Misc queries) | |||
Splitting a text string into string and number | Excel Discussion (Misc queries) | |||
Determine number of days | Excel Worksheet Functions |