Posted to microsoft.public.excel.misc
|
|
FIND LETTER IN CELL (cond. form mult entries not wrking)
Ooops!
Disregard this:
...but the OR version is 1 character shorter! <g
I guess that means it's time for some nourishment! I must consume mass
quantities!
--
Biff
Microsoft Excel MVP
"T. Valko" wrote in message
...
Yeah, that'll work...
...but the OR version is 1 character shorter! <g
Speaking of shorter...
The pedantic approach is to use ISNUMBER:
ISNUMBER(MATCH(...))
ISNUMBER(SEARCH(...))
ISNUMBER(FIND(...))
Lately, I've been moving away from ISNUMBER to COUNT (where applicable)
--
Biff
Microsoft Excel MVP
"Rick Rothstein (MVP - VB)" wrote in
message ...
Of course, as David pointed out, my faulty formula was attempting to
answer the wrong question; but, had the question actually been to match
the outer two characters, I think this formula would have worked
correctly...
=REPLACE(A1,2,LEN(A1)-2,"")="hh"
Assuming that a case insensitive match was desired.
Rick
"Rick Rothstein (MVP - VB)" wrote
in message ...
True enough... and I'll use the same excuse I gave to David in his
sub-thread for missing that fact.<g
Rick
"T. Valko" wrote in message
...
For your first conditional formula...
=ISNUMBER(SEARCH("h*h",A1))
That will find false positives like:
thigh
thorough
haha
happy birthday
--
Biff
Microsoft Excel MVP
"Rick Rothstein (MVP - VB)" wrote
in message ...
What about this? For your first conditional formula...
=ISNUMBER(SEARCH("h*h",A1))
and for your second conditional formula...
=ISNUMBER(SEARCH("h*x",A1))
Note, both of these are case insensitive.
Rick
"Nastech" wrote in message
...
in Conditional Format, trying to shorten many examples of:
=OR(LEFT(CM9,1)="h",RIGHT(CM9,1)="h")
to something like:
=OR(FIND(CM9,"H"),FIND(CM9,"X"))
but cannot get multiple items to be valid in a conditional format.
is there
another way or something doing wrong? thanks.
|