How to Use the SUBSTITUTES Function in WPS on Windows

Last updated:July 20, 2026

Use SUBSTITUTES with 1 how-to topic, including entering and confirming the function in a worksheet cell; choose the topic from the index and follow the steps.

How-to Index

No.TopicMembership
11. Use the SUBSTITUTES functionFree

How-to Guide

1. Use the SUBSTITUTES 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. Type SUBSTITUTES( and review the syntax guidance that appears.
  4. Enter the required parameters based on the guidance.
  5. Press Enter to confirm and view the calculation result in the cell.

Success Criteria

  • On-screen result: the cell displays the function result.
  • Next actions available: you can continue editing parameters, copy the formula, or fill it down.

Tips While Using

  • Start the formula with =.
  • Check that parentheses are complete and parameter separators are correct.
  • If the result looks incorrect, confirm that referenced cells contain the expected data type.