View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ms-Exl-Learner Ms-Exl-Learner is offline
external usenet poster
 
Posts: 506
Default 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.