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 ()
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top