I currently have a column of names(first and last), some are all caps, some are both caps and lower case, some have a middle initial with a period, and some don't have a middle name at all.
I'd like them all to have the first letter of each name capital and the rest of the name lower case so...