? 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

Try this:

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

Hopes this heps.

---
Per

"kirkm" skrev i meddelelsen
news(E-Mail Removed)...
>? 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

Try this

InStr(1, "enough tables and Chairs to seat 236", "chairs", 1)

Mike

"kirkm" wrote:

> ? 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
>

Convert the text string and search string to the same case and then use Instr.

Lcase() for lower case
Ucase() for upper case

If this post helps click Yes
---------------
Jacob Skaria


"kirkm" wrote:

> ? 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
>

Jacob,

You don't need to do that with instr, you can use the optional switch of 1
(VBTextCompare) and it ignores case. If you use the switch you have to
specify the other optional start character.

Mike

"Jacob Skaria" wrote:

> Convert the text string and search string to the same case and then use Instr.
>
> Lcase() for lower case
> Ucase() for upper case
>
> If this post helps click Yes
> ---------------
> Jacob Skaria
>
>
> "kirkm" wrote:
>
> > ? 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
> >

Thanks everyone. Figured it all out and learned something new.

Cheers - Kirk

Actually, I like using the built-in constant names rather than their
numerical equivalents (I find that makes the code more self-documenting)...

InStr(1, "enough tables and Chairs to seat 236", "chairs", vbTextCompare)

--
Rick (MVP - Excel)


"Mike H" <(E-Mail Removed)> wrote in message
news:E9519CBB-95B3-40CD-B2FD-(E-Mail Removed)...
> Jacob,
>
> You don't need to do that with instr, you can use the optional switch of 1
> (VBTextCompare) and it ignores case. If you use the switch you have to
> specify the other optional start character.
>
> Mike
>
> "Jacob Skaria" wrote:
>
>> Convert the text string and search string to the same case and then use
>> Instr.
>>
>> Lcase() for lower case
>> Ucase() for upper case
>>
>> If this post helps click Yes
>> ---------------
>> Jacob Skaria
>>
>>
>> "kirkm" wrote:
>>
>> > ? 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
>> >