If the cell contains..., do something
"Clivey_UK" ¦b¶l¥ó
¤¤¼¶¼g...
I'm not sure how you could do this with conditional formatting, which is
what you need for the last part of your question.
However, you also need to say do a count, so try the following for
point 1)
a) =IF(LEFT(A1,6)="senior","Yes","")
b) =IF(ISERR(IF(SEARCH("March",A1,1)0,1,"")),"","Yes ")
c) =IF(RIGHT(A1,3)="boy","Yes","")
d) As b) which just finds the word March anywhere in the text.
Hope this helps.
Clive
As to (b), my intention is to find word which happens in the middle only! Eg:
- March 30
- 30 March
- 2 March., 2000
The first one: Wrong! The word is at the start!
The second one: Wrong! The word is at the end!
Only the last one is true.
Any way to do so?
Thank you!
|