Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
080425 FIND 1 char in cell of any 3 char =True
been having trouble figuring out SEARCH & FIND, trying to find if a character in a cell is present. do not see any TRUE/FALSE examples, just a bunch of errors. finally have following work in a cond. format: =SEARCH(A9,$A$2) where only 1 character/number exists in A9, and multiple chars in $A$2 now need to test A9 if has "H" for e.g.: HLA actually need to test for multiple characters in A9, e.g.: "X","H" would use fixed cell to test for, to save space would use smaller functions to save space, FIND instead of SEARCH, but not critical thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
8500 cells with phone number(7 char.), wishing to add area code (10 char.) | Excel Discussion (Misc queries) | |||
Find if nth char = specific character.. | Excel Discussion (Misc queries) | |||
finding char within a cell | Excel Worksheet Functions | |||
Finding char within a cell | Excel Worksheet Functions | |||
How do I remove Char(160) from a cell? | Excel Worksheet Functions |