PROPER will convert your text

 

This happens a lot. You export data into Excel and everything is in caps. It’s difficult to read and won’t go over well when you present. 

The PROPER function will convert your text into normal capitalization rules (first letter uppercase, following letters lowercase.).

Tip:  It’s a good idea to copy-paste values after completing this text. You’ll likely delete out the all-caps column after writing this formula, in which case your PROPER formula will be referring to a cell that doesn’t exist. You will get an error message.

PROPER

Subscribe to my mailing list.

Leave a Reply

%d bloggers like this: