ExcelBanter - Init Caps

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Init Caps (https://www.excelbanter.com/excel-worksheet-functions/251890-init-caps.html)

msnyc07

Init Caps

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?

Bernard Liengme

Init Caps

No. Excel cannot know that QuickBooks is a trade name

--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP

"msnyc07" wrote in message
...
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?

msnyc07

Init Caps

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" wrote in message
...
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?

.

David Biddulph[_2_]

Init Caps

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" wrote in message
...
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?

.

All times are GMT +1. The time now is 02:32 PM.