Text Help

[paulfitz320]

Thanks Julie

That worked fine.

Now is it possible to check for more then one word, could I for exampl
check if the sentence contained "prominent" or "chased leaders" an
assign a value if it contained either of these comments

Cheers

Pau

 

[JulieD]

Hi Paul

one way
=IF(AND(ISERROR(FIND("prominent",E17)),ISERROR(FIND("chased
leaders",E17))),"",1)
where you want the same value returned for each

Cheers
JulieD