I have many text strings. Some of them ended with specific substring
For example:
novotna
novak*ova*
sered*ova*
jouda
I would like to have cell to go ret color, when string ended t
substring "ova".
In my case, it match strings "novakova" and "seredova".
I think, that conditional formating of cell have to be use. I don
know, which wild-card have to be
use before substring "ova". I think, something like "*ova" ?
Thanks
Satuch
--
satuch
-----------------------------------------------------------------------
satucha's Profile:
http://www.excelforum.com/member.php...fo&userid=2662
View this thread:
http://www.excelforum.com/showthread.php?threadid=39897