Case sensitivity of functions in Excel

  • Thread starter Thread starter Raj
  • Start date Start date
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
 
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
 
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
 
Back
Top