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.
|