How to Use the CODE Function in WPS on Windows

This how-to guide covers 4 operation topics for WPS CODE on Windows, including entering the formula, checking formula hints, using cross-sheet references, and updating results through recalculation.

How-to Index

How-to Guide

1. Enter the CODE function

Entry point: Formulas tab → formula bar

1. Open WPS Spreadsheet and select the cell where you want to enter the formula.
2. Type = in the formula bar or directly in the cell.
3. Enter CODE( to start the function.
4. Prepare the text value or cell reference that you want to calculate.

Success Criteria

• Interface result: The selected cell enters formula editing mode.
• What you can do next: You can continue entering the argument and press Enter to calculate the result.

Tips While Using

• Start the formula with =.
• It is helpful to select the target cell before entering the function.

2. Check formula hints and fill in the argument

Entry point: formula bar

1. After entering CODE(, look at the formula hint shown by the app.
2. Confirm the required argument and example from the hint.
3. Enter the correct text value or referenced cell.
4. Press Enter to confirm the formula.

Success Criteria

• Interface result: The cell displays the calculated result.
• What you can do next: You can copy the formula or edit the argument again.

Tips While Using

• Make sure the argument type and count match the function requirement.
• Keep brackets and separators complete.

3. Use CODE with a cross-sheet reference

Entry point: formula bar

1. Select the result cell.
2. Enter =CODE(.
3. Switch to another worksheet and select the cell you want to reference.
4. Complete the closing bracket and press Enter.

Success Criteria

• Interface result: The result cell returns the corresponding character code.
• What you can do next: You can continue nesting the formula with other functions.

Tips While Using

• Make sure the referenced cell contains recognizable text.
• Check the worksheet name and reference position carefully in cross-sheet formulas.

4. Update results with recalculation

Entry point: a cell that already contains the formula

1. Finish entering the CODE function and get a result.
2. Change the original text in the referenced cell.
3. Check whether the result cell updates automatically.
4. If needed, press F9 to trigger recalculation manually.

Success Criteria

• Interface result: The result updates after the source data changes.
• What you can do next: You can continue analysis or copy the updated result.

Tips While Using

• If the result looks incorrect, check for circular references or text-format issues first.
• Manual recalculation is useful when checking delayed updates.