Uppercase typing may have negative connotations when used conversationally in text messages or emails, but there are certain types of database or situations where your data needs to be in all capital letters. So if you have a spreadsheet of data that is all lowercase, or is a mixture of lowercase and uppercase, you may be looking for a way to make all of the text uppercase in Excel 2013.
Fortunately you can accomplish this with the help of a formula that can automatically make all of your text uppercase. Our guide below will show you how to use this formula, then replace your original lowercase data with the uppercase data that you need.
How to Convert to All Capital Letters in Excel 2013
The steps in this guide are going to assume that you currently have a spreadsheet with some cells that are lowercase, but you would prefer to have them uppercase. We are going to accomplish this conversion with a simple formula. The results of that formula can then be copied and pasted into the original cells, allowing you to replace the original lowercase text with the new and improved uppercase text.
Step 1: Open your spreadsheet containing the cells for which you would like to make all of the text uppercase.
Step 2: Right-click on the column heading to the right of the column with the lowercase text, then click the Insert option. This is going to add a new, empty column directly to the right of the column we are modifying.
Step 2: Click inside the cell to the right of the first cell with lowercase text, then type =UPPER(XX) , but replace the XX with the cell location containing the lowercase text. In this example, that is cell B2. Press Enter on your keyboard after completing the formula.
Step 3: Right-click on the cell containing the uppercase text, then click the Copy option.
Step 4: Select the cells into which you wish to convert the original lowercase text to uppercase text, then right-click one of the selected cells and select the Paste option.
Step 5: Select all of the cells that now contain uppercase text, then right-click on one of them and select the Copy option.
Step 6: Select the original cells that still contain the lowercase text.
Step 7: Right-click on the selected cells, then click the Paste option with the numbers on it. This is going to allow you to paste the values from the formulas rather than the formulas themselves.
Step 8: Delete the column that contains the formulas by right-clicking the column heading, then clicking the Delete option.
Do you have a lot of CSV files that you need to combine into one file, but you are looking for a better way to do it than cutting and pasting? Learn how to merge csv files with the Windows command prompt and make it much easier to combine your data into one spreadsheet.