View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
msnyc07 msnyc07 is offline
external usenet poster
 
Posts: 93
Default 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.