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.

case_1

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

Related Posts

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.

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