SPREADHSEET TIPS & TRICKS: Upper, Lower, Proper...

Here are some useful functions to help tidy a spreadsheet that contains non-numeric data. If, for example, you are given a list of names and addresses, in all lower or all uppercase, but you really need them to be in the proper format, with the first character in uppercase only, then the “proper” function can be used. Screenshot A shows an example. It’s a quick and easy way to convert a list of incorrectly formatted non-numeric data that would otherwise be timely and manual process...

Screenshot A

Incidentally, it is possible to convert data into upper and lowercase formats using the upper and lower functions in the same manner, as screenshots B and C show.

Screenshot B

Screenshot C