Quantcast

Question for Excel users

  • Come enter the Ridemonkey Secret Santa!

    We're kicking off the 2024 Secret Santa! Exchange gifts with other monkeys - from beer and snacks, to bike gear, to custom machined holiday decorations and tools by our more talented members, there's something for everyone.

    Click here for details and to learn how to participate.

N8 v2.0

N8 v2.0

Not the sharpest tool in the shed
Oct 18, 2002
11,003
149
The Cleft of Venus
dh girlie said:
Is there a formula that will change all your lower case letters to capitals without having to retype everything? Thanks...
Click to expand...

Change the case of text
Use the UPPER, LOWER, or PROPER functions to do this task.

nancy Davolio
Formula Description (Result)

=UPPER(A2) Changes text to all UPPERCASE (NANCY DAVOLIO)
=LOWER(A2) Changes text to all lowercase (nancy davolio)
=PROPER(A2) Changes text to Title Case (Nancy Davolio)
 
You must log in or register to reply here.
Top Bottom