Init Caps
in [Functions]
|
Prev: Can I Rotate with a Condition -or- Can I Display Graphics with a Formula
Next: excel 2003 allowed addition of cell color anywhere on the page?
From: msnyc07 on 27 Dec 2009 13:25 I used the Proper Function in a Column to pull records that were proper titles/names of software from a list, however it did not catch what is known sometime as 'HumpBack Caps' e.g. QuickBooks or ACT! Is there a function that will find these as well?
From: Bernard Liengme on 27 Dec 2009 14:48 No. Excel cannot know that QuickBooks is a trade name -- Bernard Liengme http://people.stfx.ca/bliengme Microsoft Excel MVP "msnyc07" <msnyc07(a)discussions.microsoft.com> wrote in message news:93705658-F035-4885-81DB-67F1FC8CB54F(a)microsoft.com... > I used the Proper Function in a Column to pull records that were proper > titles/names of software from a list, however it did not catch what is > known > sometime as 'HumpBack Caps' e.g. QuickBooks or ACT! > > Is there a function that will find these as well?
From: msnyc07 on 27 Dec 2009 16:09 So there is no function that will explicitly refer to Init Caps which to my thinking means any word that starts with a CAP vs the stricter definition of 'Formal Caps'? "Bernard Liengme" wrote: > No. Excel cannot know that QuickBooks is a trade name > > -- > Bernard Liengme > http://people.stfx.ca/bliengme > Microsoft Excel MVP > > "msnyc07" <msnyc07(a)discussions.microsoft.com> wrote in message > news:93705658-F035-4885-81DB-67F1FC8CB54F(a)microsoft.com... > > I used the Proper Function in a Column to pull records that were proper > > titles/names of software from a list, however it did not catch what is > > known > > sometime as 'HumpBack Caps' e.g. QuickBooks or ACT! > > > > Is there a function that will find these as well? > > . >
From: "David Biddulph" groups [at] on 27 Dec 2009 16:19
If you explain to us what you are trying to do, with appropriate examples, then we may be able to help you. -- David Biddulph msnyc07 wrote: > So there is no function that will explicitly refer to Init Caps which > to my thinking means any word that starts with a CAP vs the stricter > definition of 'Formal Caps'? > > "Bernard Liengme" wrote: > >> No. Excel cannot know that QuickBooks is a trade name >> >> -- >> Bernard Liengme >> http://people.stfx.ca/bliengme >> Microsoft Excel MVP >> >> "msnyc07" <msnyc07(a)discussions.microsoft.com> wrote in message >> news:93705658-F035-4885-81DB-67F1FC8CB54F(a)microsoft.com... >>> I used the Proper Function in a Column to pull records that were >>> proper titles/names of software from a list, however it did not >>> catch what is known >>> sometime as 'HumpBack Caps' e.g. QuickBooks or ACT! >>> >>> Is there a function that will find these as well? >> >> . |