I sometimes have to convert Upper case to proper case in my spreadsheets.
Is there a way to inform Proper to leave certain characters alone (on the fly).
Like words that are have prefixes in front of them (like MacDongual instead of Macdongual, or McConnell instead of Mcconnell). It seems to...