'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Convert Excel Text to Uppercase with the UPPER Function
Question details
The user wants to learn how to convert lowercase or mixed-case text to all uppercase letters in an Excel worksheet using the UPPER function.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Standardizing text formatting for names, labels, and other data within a spreadsheet.
- Observed behavior
- Text is currently in mixed case or lowercase and needs to be converted entirely to capitalized letters.
Ensure that you have an empty column next to your target data to input the new formula without overwriting any existing spreadsheet information.
Use the UPPER Function to Capitalize Text
This method uses Excel's built-in formula to convert any text string into all uppercase letters instantly.
The UPPER function is a built-in text function in Excel that takes a cell reference and converts all alphabetical characters within that cell to uppercase. It is highly effective for cleaning up inconsistent data entries.
Select an empty cell next to the text you want to convert (for example, click cell B1 if your original text is in A1). Type the formula =UPPER(A1) and press Enter.
Click the bottom-right corner of the cell containing the formula and drag the fill handle down to apply the uppercase conversion to the rest of the rows in your column.
Select the newly generated uppercase results in column B and press Ctrl+C to copy them.
Right-click the original text range in column A, select Paste Special, and choose Values. This replaces the old text with the new uppercase text, allowing you to safely delete the formula column.
Standardize Your Data Formatting with WPS Spreadsheet
WPS Spreadsheet offers powerful data processing tools, including full support for the UPPER, LOWER, and PROPER text functions, making it incredibly easy to clean and format your data exactly as you need it without paying for expensive software.
- 1. Open your workbook: Launch WPS Spreadsheet and open the file containing the text you want to format.
- 2. Enter the UPPER function: Select an adjacent blank cell, type =UPPER(A1), and press Enter.
- 3. Fill down the formula: Drag the fill handle at the bottom right of the cell to convert the rest of your column to uppercase.
- 4. Paste as values: Copy the new uppercase text, right-click the original cells, and select 'Paste as Values' to overwrite the old data permanently.
Frequently Asked Questions
Can I convert text to lowercase or proper case instead?
Yes, you can use the =LOWER(A1) function to convert text to all lowercase letters, or the =PROPER(A1) function to capitalize only the first letter of each word.
Why does my text disappear when I delete the original column?
The formula dynamically references the original cell. If you delete the original cell, the formula has nothing to reference. You must first copy the formula results and use Paste Special > Values to lock in the text before deleting the original column.
Is there a shortcut to change case without formulas in Excel?
Unlike Microsoft Word, Excel does not have a built-in 'Change Case' button on the ribbon. Using formulas like UPPER, or utilizing the Flash Fill feature (Ctrl+E) by typing an example of the uppercase text, are the most efficient ways to change text case.
Will the UPPER function affect numbers or punctuation?
No, the UPPER function only affects alphabetical characters. Numbers, punctuation marks, and special symbols will remain exactly as they were in the original text.
