Capitalize words within parentheses

I am using Excel 2010.

In a spreadsheet I have to change text in various places to proper case. I have some exceptions such as the word 'of'. All this works.

Is there any way for me to capitalize words around parentheses. Any word wrapped in parentheses is a government acronym and should be capitalized. Currently after running this macro, (FDA) comes out as (Fda).

Thank you for your help.

--Perry

Please Login or Register  to view this content.