Text Help
Thanks Julie That worked fine. Now is it possible to check for more then one word, could I for example check if the sentence contained "prominent" or "chased leaders" and assign a value if it contained either of these comments Cheers Paul -- paulfitz320 ------------------------------------------------------------------------ paulfitz320's Profile: http://www.excelforum.com/member.php...fo&userid=6643 View this thread: http://www.excelforum.com/showthread...hreadid=278208 |
Hi Paul
one way =IF(AND(ISERROR(FIND("prominent",E17)),ISERROR(FIN D("chased leaders",E17))),"",1) where you want the same value returned for each Cheers JulieD "paulfitz320" wrote in message ... Thanks Julie That worked fine. Now is it possible to check for more then one word, could I for example check if the sentence contained "prominent" or "chased leaders" and assign a value if it contained either of these comments Cheers Paul -- paulfitz320 ------------------------------------------------------------------------ paulfitz320's Profile: http://www.excelforum.com/member.php...fo&userid=6643 View this thread: http://www.excelforum.com/showthread...hreadid=278208 |
All times are GMT +1. The time now is 10:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com