Metropol

Hi, I'm appealing to any of you who know a bit about logical tests in Excel.

Basically, how can I do the logical test on whether or not a string is present in a field? I.E., a cell containing the word "example" contains the string "ample", so a logical test on that cell for the presence of the word "ample" should return true.

It might not even be possible -- if I have to go into Excel Visual Basic to do it then forget it. Any ideas?

Cheers

Chris

This should help:
IF(ISTEXT(A1),"Your text",Thing to output)

Sput wrote:This should help:
IF(ISTEXT(A1),"Your text",Thing to output)

Just the function I was after! I know the javascript equivelant (indexOf, of course) but Excel is all different like that.

Cheers