I'm using Google Sheets glued together (not be me) from multiple sources where some of the names are in all caps. In trying to clean web-ready content, I have good success with the
PROPER() function except when it is a name with an apostrophe.
If the cell contains
SMITTY'S running it through the
PROPER() function returns
Smitty'S and is ugly. Any clever ideas around this?