Hi,

Which Excel functions are case sensitive and which are not?

Can anyone shed some light or point to some resource that explains the
case sensitivity of functions in Excel?

Thanks in advance.

Regards,
Raj

Most functions are not case sensitive, but you can use the EXACT
function if case is important to you. FIND is case-sensitive, but
SEARCH is not.

Hope this helps.

Pete

On Jun 2, 1:37*am, Raj wrote:
Hi,

Which Excel functions are case sensitive and which are not?

Can anyone shed some light or point to some resource that explains the
case sensitivity of functions in Excel?

Thanks in advance.

Regards,
Raj

SUBSTITUTE is also case sensitive.

--
Biff
Microsoft Excel MVP


"Pete_UK" wrote in message
...
Most functions are not case sensitive, but you can use the EXACT
function if case is important to you. FIND is case-sensitive, but
SEARCH is not.

Hope this helps.

Pete

On Jun 2, 1:37 am, Raj wrote:
Hi,

Which Excel functions are case sensitive and which are not?

Can anyone shed some light or point to some resource that explains the
case sensitivity of functions in Excel?

Thanks in advance.

Regards,
Raj