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

Similar Threads

All caps to Proper caps 6
Spell check problems with forms and macros 13
Grammar Check 2
Migrating Forms created in Word 2003 to Word 2007 8
How to eliminate records that are used to test a created database 6
Just read this. It could help. 0
Better communication in the next office release required. 0
This could change your life: Just read it: J M.Hall 0

Top