Lower Case to Upper Case

B

Barnesie

Is there a way to change a column of data from lower case to upper case
without retyping the information?
 
C

Corundum

Use either of the functions:

=UPPER() to convert all letters to upper case
=PROPER() to convert only the first letter of each word to upper

reference the cell to convert in the ()
 
Top