[dh girlie]

Is there a formula that will change all your lower case letters to capitals without having to retype everything? Thanks...

 

[N8 v2.0]

Is there a formula that will change all your lower case letters to capitals without having to retype everything? Thanks...

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)