Try this:

instr(LCase("enough tables and Chairs to seat 236"), "chairs")

Hopes this heps.

---
Per

"kirkm" skrev i meddelelsen
...
? instr("enough tables and Chairs to seat 236", "chairs")

This returns 0 because I'm not using a capital "C" in chairs

Is there a command to cause Excel to be non case-specific ?

Thanks - Kirk