Case sensitivity of functions in Excel

[Raj]

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

 

[Pete_UK]

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

 

[T. Valko]

SUBSTITUTE is also case sensitive.

--
Biff
Microsoft Excel MVP


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