How to Change from Lowercase to Uppercase in Excel

Method 1 of 4:

Using the Uppercase Function

Type in a series of names or text in a column in your worksheet. Your text can be in any case when using this function. It will change the text in the cell to all uppercase letters.
Add a column to the right of your text column. Click on the letter on the top of the text column. Right click and select 'Insert.'
Move your cursor into the cell to the right of the first data you want to capitalize. You will place a formula with the uppercase function in this cell.
Press the function button in the top toolbar. It is a blue epsilon symbol and looks like the letter 'E.' The formula bar (fx) will be highlighted so that you can type in your function.
Select the text function labeled 'UPPER' or type in the word 'UPPER' next to the equals sign in your formula bar.
1. When you press the function button, the word 'SUM' may automatically appear. If this happens, replace 'SUM' with 'UPPER' to change the function.^[1]
Type the cell location in parenthesis next to the word UPPER. If you were using the first column and row for your data, your function bar would read '=UPPER(A1).'
Press 'Enter.' The text in cell A1 should appear in cell B1 in all-uppercase letters.
Click your cursor on the little box in the bottom right corner of the cell. Drag the box to the bottom of the column. This will fill in the series so that each cell in the first column is copied to the second column in the uppercase.
Check that all of the text has been correctly copied into the second column. Highlight the column above the correct text by clicking on the letter above the column. Click on the 'Edit' menu and click 'Copy,' and then click the 'Edit' drop down menu and select 'Paste Values.'
1. This process will allow you to replace the formula with the value, so that you can delete the first column of text.
Check that the same text reappears in the column. Delete the first column by right clicking the letter above the column. Select 'Delete' from the drop down list.

Method 2 of 4:

Using the Proper Name Function

Enter your text into the first column of your spreadsheet. This function will help you to capitalize the first letter of your text in each cell.
Add a new column. Right click on the letter heading the first column. Select 'Insert' in the drop down menu.
Move your cursor to the cell to the right of the first text entry. Click the formula button. This is the blue epsilon symbol in the top horizontal toolbar.
Click on the formula bar. It is a query bar next to the 'fx' sign just above your spreadsheet. Type the word 'PROPER' after the equals sign.
1. If the word 'SUM' automatically appeared in the formula bar, replace it with the word 'PROPER' to change the function.
Type the first cell location of your text in parenthesis next to the word 'PROPER.' For example, it should read '=PROPER(A1).'
Press 'Enter.' The first letter of each word in the cell should be capitalized in the column to the right of the original text. The rest of the text will be lowercase.^[2]
Grab the box in the lower right corner of the cell. Drag it down the column until you are at the bottom of your original text column. Release the mouse, and all the text should have copied with the first letters capitalized.
Click on the letter at the top of your replacement column to select the entire column. Click the 'Edit' menu and select 'Copy.' Then, click the drop down menu on the Paste button and select 'Paste Values.'
1. The formula based cells will be replaced with the text, so that you can delete the first column.
Right click on the first column. Select 'Delete' to get rid of it and leave the replacement values with proper cases.

Method 3 of 4:

Using Flash Fill in Excel 2013

Use this section if your series is a list of proper names. It will need to be written in Excel in the lowercase to use this method. The flash fill function can read and change names so that the first letter of the first and last name is capitalized.
Complete your list of names using lowercase letters. Enter them in a single column. Leave a blank column to the right of the list of names.
1. If you don't currently have a blank column to the right of your list of names, right click on the lettered column above your list of names. Select 'Insert' and a new empty column will appear to the right.
Click on the cell to the right of the first name that is listed. For example, if your first lowercase name were in cell A1, you would go to cell B1.
Type the same name as the cell in A1, but include proper capitalization of first and last names. For example, if the first cell says 'joe biggins,' type 'Joe Biggins' in the cell to the right. Press 'Enter.'
Go to the 'Data' menu and select 'Flash Fill.' It will learn the pattern and make a similar change in the data series. You can also use the short cut code, 'Control' and the letter 'E' to activate Flash Fill.^[3]
Delete the column with the lowercase names. To avoid duplication, click on the top of the original lowercase column. Right click and press 'delete' to get rid of it and leave the list with proper cases.
1. Make sure Flash Fill has worked on your whole list before deleting.

Method 4 of 4:

Using Word

An alternative to writing Excel formulas to change the case which is very quick is this:
Open a blank Word document
In Excel, highlight the cells that you want to change the case in
Copy the cells (Control "C")
Paste it into the Word document (Control "V")
Highlight all the text in the Word Document
Click on the "Change Case" dropdown menu in the "Home" tab
Choose the option you would like - Sentence case, lowercase, UPPERCASE, Capitalize Each Word, tOGGLE cASE
After the case has changed, highlight all the text and paste it back into Excel
The whole process takes a few seconds

Marvin Fry

Update 05 March 2020

You should read it

May be interested

How to Create a Custom Macro Button in Excel
macros in excel can save a great deal of time with repetitive tasks. by assigning macros to custom buttons, you can save even more time by bringing your macro only one-click from execution. click tools → customize.
How to Freeze Cells in Excel
this wikihow teaches you how to freeze specific rows and columns in your microsoft excel worksheet. freezing rows or columns ensures that certain cells remain visible as you scroll through the data. if you want to easily edit two parts of...
How to Round in Excel
this wikihow teaches you how to round the value of a cell using the round formula, and how to use cell formatting to display cell values as rounded numbers. enter the data into your spreadsheet.
How to Create a Timeline in Excel
excel isn't heavy on the graphics, but there are still several ways to create a timeline. if you have excel 2013 or later, you can even create it automatically from a pivot table. earlier versions will have to rely on smartart, templates,...
How to Create Pivot Tables in Excel
pivot tables are interactive tables that allow the user to group and summarize large amounts of data in a concise, tabular format for easier reporting and analysis. they can sort, count, and total the data, and are available in a variety...
How to Copy Formulas in Excel
excel makes it easy to copy your formula across an entire row or column, but you don't always get the results you want. if you end up with unexpected results, or those awful #ref and /div0 errors, read about absolute and relative cell...