Lower Case to Upper Case

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to change a column of data from lower case to upper case
without retyping the information?
 
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 ()
 
You must log in or register to reply here.

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

Similar Threads

Upper / Lower Case 1
convert lower to upper case automatically without using UPPER 6
Format Cell - Only Upper Case Alpha characters 3
CHANGE LOWER CASE TO UPPER CASE? 1
change to upper/lower case 1
Formatting cells to only upper case 5
Upper Case Conversion 4
Title Case in Excel 3

Back
Top