WPS Features
Resources
Free AI Tools
Docs Center

How to Use the SCAN Function in WPS on Windows

Last updated:July 13, 2026

Use the SCAN function through 3 task topics, all available without membership; choose a topic from the How-to Index and follow the steps to enter, review, or check the function.

How-to Index

No.TopicMembership Requirement
11. Enter SCAN through the Insert Function dialog boxFree
22. Type the formula directly in a cellFree
33. Review function syntax and parameter detailsFree

How-to Guide

1. Enter SCAN through the Insert Function dialog box

Entry point: Formula tab → Insert Function

  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 SCAN in the Insert Function dialog box.
  4. Select the function and click OK.
  5. Fill in the parameters in the Function Arguments dialog box.
  6. Click OK to finish entering the function.

Success Criteria

  • The SCAN function is inserted into the target cell.
  • You can continue editing parameters or review the calculation result.

Tips While Using

  • Enter the full function name to find it faster in the search box.
  • Confirm the target cell and referenced range before filling in parameters.

2. Type the formula directly in a cell

Entry point: Cell → Formula bar

  1. Select the cell where you want to enter the formula.
  2. Type =SCAN(...) directly in the cell or formula bar.
  3. Press Enter to confirm.
  4. If you want to review parameter details, type =SCAN( and press F1 to view syntax guidance.

Success Criteria

  • The formula is entered in the cell or formula bar.
  • After you press Enter, you can review the returned result or continue editing.

Tips While Using

  • Use English punctuation for separators to avoid formula parsing issues.
  • When copying the formula to other cells, check whether the referenced range should change.

3. Review function syntax and parameter details

Entry point: Formula tab → Insert Function

  1. Click Insert Function on the Formula tab.
  2. Enter SCAN in the search box.
  3. Select the function to review its syntax.
  4. Click the help link for more detailed information.

Success Criteria

  • You can review the SCAN function name, syntax, or parameter details.
  • You can continue entering or revising the formula based on the information shown.

Tips While Using

  • Keep your internet connection available if the help page needs to load online content.
  • Check parameter order before entry to reduce formula errors.