| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? . |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In excel can you change words from all caps to initial caps? | Excel Discussion (Misc queries) | |||
| Formula to check for Init Caps (not just 'Proper') | Excel Discussion (Misc queries) | |||
| How to change ALL CAPS to Initial Caps only? | Excel Worksheet Functions | |||
| How can I convert all Caps to first letter caps in Excel? | Excel Worksheet Functions | |||
| excel sheet all caps and needs to be only the first letter caps.. | Excel Discussion (Misc queries) | |||
Linear Mode
