| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I evaluate whether a character is present in a cell?
I am hoping I can evaluate whether a specific character is present in the
text of a cell using an If function. For example if I test for a forward-slash in a cell containing the text abc/def I want a TRUE result but in a cell containing the text abcdef I want a FALSE result. Is this possible? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I evaluate whether a character is present in a cell?
Actually, you don't even need to use IF:
=LEN(A1)LEN(SUBSTITUTE(A1,"/","")) will return TRUE if A1 contains / or FALSE if it doesn't. Hope this helps, Hutch "Crash" wrote: I am hoping I can evaluate whether a specific character is present in the text of a cell using an If function. For example if I test for a forward-slash in a cell containing the text abc/def I want a TRUE result but in a cell containing the text abcdef I want a FALSE result. Is this possible? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I evaluate whether a character is present in a cell?
On Sat, 28 Nov 2009 20:05:01 -0800, Crash
wrote: I am hoping I can evaluate whether a specific character is present in the text of a cell using an If function. For example if I test for a forward-slash in a cell containing the text abc/def I want a TRUE result but in a cell containing the text abcdef I want a FALSE result. Is this possible? =ISNUMBER(SEARCH("/",A1)) =ISNUMBER(FIND("/",A1)) If you are looking for a letter, SEARCH is case-insensitive; FIND is case-sensitive. Also look up HELP for wildcards in case you need to find one of them. --ron |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I evaluate whether a character is present in a cell?
Use FIND() or SEARCH().
=ISNUMBER(FIND("/",A1)) =IF(ISNUMBER(FIND("/",A1)),"true statement","false statement") If this post helps click Yes --------------- Jacob Skaria "Crash" wrote: I am hoping I can evaluate whether a specific character is present in the text of a cell using an If function. For example if I test for a forward-slash in a cell containing the text abc/def I want a TRUE result but in a cell containing the text abcdef I want a FALSE result. Is this possible? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I evaluate whether a character is present in a cell?
Another one...
=COUNTIF(A1,"*/*")0 -- Biff Microsoft Excel MVP "Crash" wrote in message ... I am hoping I can evaluate whether a specific character is present in the text of a cell using an If function. For example if I test for a forward-slash in a cell containing the text abc/def I want a TRUE result but in a cell containing the text abcdef I want a FALSE result. Is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I evaluate A1 from cell A2 and place a value into A3? | Excel Discussion (Misc queries) | |||
| evaluate cell value with sheet name | Excel Worksheet Functions | |||
| Display characters present after a specific character | Excel Discussion (Misc queries) | |||
| How do I evaluate a row of cells for a character in each cell? | Excel Worksheet Functions | |||
| "There is no office assistant character file present on this syste | Excel Discussion (Misc queries) | |||
Linear Mode
