Grabbing the right case

Excel has three functions that handle case. LOWER,  UPPER and PROPER.

See image below for the results of using these functions. Cell A2 contains an entry.


Cell B2 has =LOWER(A2)
Cell C2 has =UPPER(A2)
Cell D2 has =PROPER(A2)

Note: The PROPER function capitalises the first letter of every word in the cell – see below.

proper function

Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.