How to Use the SEARCH Function in WPS on Windows

Last updated:July 23, 2026

Use the SEARCH function with 3 how-to topics; all 3 are available without membership and 0 are membership-related.

How-to Index

No.TopicMembership Requirement
11. Create a formula field and call SEARCHFree
22. Review the argument format and enter the formulaFree
33. Use a SEARCH formula exampleFree

How-to Guide

Entry path: Add Field → Formula

  1. Open the target multi-dimensional table.
  2. Click Add Field.
  3. Select the Formula field type.
  4. Enter a SEARCH formula in the formula editor.
  5. Click Confirm and check whether the result appears in the field.

Success Criteria

  • Interface result: a new formula field appears in the table.
  • Next action available: you can continue editing the formula and review the calculated result.

Tips While Using

  • Common mistake: if you do not choose the Formula field type, you cannot enter the function.
  • Environment note: you need edit permission for the current multi-dimensional table.

2. Review the argument format and enter the formula

Entry path: Formula Editor → Function Library → SEARCH

  1. Open the function library in the formula editor.
  2. Select SEARCH to review its format.
  3. Enter the text to find and the text to search.
  4. If needed, add a start position or related expressions.
  5. Save the formula and review the returned result.

Success Criteria

  • Interface result: the full function expression appears in the formula editor.
  • Next action available: after saving, you can see the calculated result in records.

Tips While Using

  • Common mistake: entering arguments in the wrong order can cause unexpected results.
  • Environment note: the text content in referenced fields should match the formula logic.

3. Use a SEARCH formula example

Entry path: Formula field editing area

  1. Create or select a formula field.
  2. Enter an example formula that includes SEARCH.
  3. Test it with text fields in the current record.
  4. Check whether the result refreshes when data changes.
  5. Combine it with IF or other functions if needed.

Success Criteria

  • Interface result: the formula field returns the expected lookup result.
  • Next action available: when source data changes, the result updates as well.

Tips While Using

  • Common mistake: if the example formula references the wrong field, the result will not match expectations.
  • Environment note: test with a small number of records before wider use.