Case sensitivity of functions in Excel

R

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
 
P

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

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
 
Top