| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to check for Init Caps (not just 'Proper')
I have a spreadsheet I want to extract some software titles from. I made the
(good) assumption that Init Caps would get me there so used; =IF(EXACT(I2,PROPER(I2)), I2, "") The problem as any actually experienced programmers (which I am not) can immediately guess is that this does not catch; Word BigWord Word 4 Word Word ABCD Is there anyway to tweak this easily or am I stuck with some ridiculously complex nested code? I was liking the simplicity... Any suggestions appreciated. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to check for Init Caps (not just 'Proper')
Sorry I Cant able to understand what you are looking for. Can you please
explain what do you want to do? -------------------- (Ms-Exl-Learner) -------------------- "msnyc07" wrote: I have a spreadsheet I want to extract some software titles from. I made the (good) assumption that Init Caps would get me there so used; =IF(EXACT(I2,PROPER(I2)), I2, "") The problem as any actually experienced programmers (which I am not) can immediately guess is that this does not catch; Word BigWord Word 4 Word Word ABCD Is there anyway to tweak this easily or am I stuck with some ridiculously complex nested code? I was liking the simplicity... Any suggestions appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing all caps to proper | Excel Discussion (Misc queries) | |||
| proper formula - how to make the state be CAPS | Excel Discussion (Misc queries) | |||
| Is there a way to change Lowercase or Proper to ALL CAPS? | Excel Worksheet Functions | |||
| Converting All Caps to Proper casing | Excel Worksheet Functions | |||
| How do I change a spreadsheet from all caps to "Proper" | Excel Discussion (Misc queries) | |||
Hybrid Mode
