WPS Features
Resources
Free AI Tools
Docs Center

How to Use the SUBSTITUTE Function in WPS on Windows

Last updated:July 13, 2026

Use the SUBSTITUTE function in 3 how-to topics on Windows, and choose the method you need from the index below.

How-to Index

No.TopicMembership Requirement
11. Insert it from the Insert Function dialog boxFree
22. Type the formula directly in a cellFree
33. Check syntax and parameter detailsFree

How-to Guide

1. Insert it from the Insert Function dialog box

Entry point: Formula tab → Insert Function, or the fx button in the formula bar

  1. Select the cell where you want to enter the formula.
  2. Click the fx button in the formula bar, or click Insert Function on the Formula tab.
  3. Search for SUBSTITUTE in the dialog box.
  4. Select the function and click OK.
  5. Enter each parameter in the function arguments dialog box.
  6. Click OK to finish inserting the function.

Success Criteria

  • The current cell contains a SUBSTITUTE formula.
  • The values entered in the parameter dialog box are written into the cell or formula bar.
  • You can continue by pressing Enter or using the fill handle.

Tips While Using

  • Searching with the full function name SUBSTITUTE can help you find it faster.
  • Follow the parameter order shown in the dialog box to avoid unexpected results.

2. Type the formula directly in a cell

Entry point: A worksheet cell or the formula bar

  1. Select the cell where you want to enter the formula.
  2. Type =SUBSTITUTE(...) directly in the cell or formula bar.
  3. Press Enter to confirm.
  4. If needed, copy the formula or drag the fill handle to other cells.

Success Criteria

  • The cell shows a calculated result instead of plain text.
  • When the cell is selected, the full SUBSTITUTE formula appears in the formula bar.
  • The formula can be copied to nearby cells.

Tips While Using

  • Use English commas to separate parameters.
  • If the result looks incorrect, check the referenced cell content and replacement text first.

3. Check syntax and parameter details

Entry point: Formula tab → Insert Function

  1. Click Insert Function on the Formula tab.
  2. Enter SUBSTITUTE in the search box.
  3. Select the function to review its syntax and parameter details.
  4. Click the help link for more detailed guidance.

Success Criteria

  • You can see the syntax structure and parameter prompts for SUBSTITUTE.
  • You can tell what each parameter means and where to enter it.
  • You can return to the worksheet and continue editing the formula.

Tips While Using

  • If the result does not match your expectation, review the parameter meanings again before changing the formula.
  • Keep your network connection available if the help page opens online.