Formula to check for Init Caps (not just 'Proper')

M

msnyc07

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

Ms-Exl-Learner

Sorry I Can’t able to understand what you are looking for. Can you please
explain what do you want to do?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top