Excel UPPER Function Not Working? Fix Text Formatting and Formula Display in WPS Office
Question details
The user needs to resolve why the Excel UPPER function is not converting text to uppercase and why the destination cell may show the formula text instead of the result.
- Product
- WPS Office Spreadsheet
- Device & OS
- not provided
- Scenario
- The user entered a formula such as =UPPER(J2) and expected the calculated uppercase result to appear in the destination cell.
- Observed behavior
- The destination cell displays the formula as text or does not update to uppercase, often because the cell is formatted as Text or Show Formulas is enabled.
Check whether the destination cell shows the formula instead of the result, and make sure the workbook is open for editing before changing cell formats or formula display settings.
Change destination cells to General and turn off Show Formulas
Use this solution when the UPPER function returns the formula text or the original value instead of the uppercase result.
Excel and WPS Office treat formulas differently when the destination cell is formatted as Text. In Text format, the formula is displayed as typed instead of calculated. Show Formulas also displays every formula in the worksheet rather than its result.
Select the cells that contain or will contain the UPPER formula, right-click and choose Format Cells, click General, and select OK.
Click the destination cell, type =UPPER(J2) or edit the existing formula, and press Enter so the formula is recalculated in the new General format.
Open the Formulas tab on the ribbon and click the Show Formulas button to deselect it if it is highlighted.
Go to the Formulas tab, open Calculation Options, and choose Automatic so the UPPER result updates when the source text changes.
Use WPS Office Spreadsheets to Fix the UPPER Function
WPS Office Spreadsheets can directly handle the UPPER function and Excel formula display settings. Set the destination cell format to General, disable Show Formulas, and switch to Automatic calculation to display the uppercase result correctly.
- 1. Open WPS Office Spreadsheets: Launch WPS Office and open the workbook that contains the UPPER function issue.
- 2. Set the destination cell format: Select the result cell, right-click, choose Format Cells, click General, and confirm.
- 3. Re-enter the UPPER formula: Type =UPPER(source_cell) in the destination cell and press Enter.
- 4. Turn off Show Formulas: Go to the Formulas tab and deselect Show Formulas.
- 5. Set Automatic calculation: In the Formulas tab, open Calculation Options and choose Automatic.
Frequently Asked Questions
Why does my Excel UPPER formula show as text instead of calculating?
The destination cell is likely formatted as Text. Select the cell, right-click, choose Format Cells, set the format to General, then re-enter the formula and press Enter.
How do I turn off Show Formulas in WPS Office or Excel?
Go to the Formulas tab on the ribbon and click Show Formulas to deselect it. The worksheet will then display formula results instead of formula text.
Does the UPPER function work only with text?
Yes, UPPER converts a text string to uppercase. If the source cell contains a number or is empty, the result will show that value without an uppercase text conversion.
Why does my formula not update after I edit the source cell?
Calculation may be set to Manual. Go to the Formulas tab, open Calculation Options, and select Automatic.
