Case sensitivity of functions in Excel
in [Functions]
|
Prev: How do I put a blank value in a cell not using "" in a formula
Next: Cut, copy & paste functions in Excel 2007 are extremely slow.
From: Raj on 1 Jun 2010 20:37 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
From: Pete_UK on 1 Jun 2010 20:47 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 <rsp...(a)gmail.com> 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
From: T. Valko on 1 Jun 2010 22:12
SUBSTITUTE is also case sensitive. -- Biff Microsoft Excel MVP "Pete_UK" <pashurst(a)auditel.net> wrote in message news:ebb2ad0d-06f9-4e13-bdb9-65f124e8f4cb(a)a20g2000vbc.googlegroups.com... 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 <rsp...(a)gmail.com> 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 |