SUBSTITUTES in WPS Spreadsheet is a built-in formula entry feature for Windows; this guide covers 3 core tasks, with 3 available without membership and 0 membership-related items.
At a Glance
| Metric | Value | Notes |
|---|
| Core tasks | 3 | Matches the number of rows in the How-to Index |
| Available without membership | 3 | Matches the number of Free rows in the index |
| Membership-related items | 0 | Matches the number of membership-related rows in the index |
About This Feature
Overview
SUBSTITUTES is a built-in function in WPS Spreadsheet for data processing and calculation in worksheet cells. You can insert it from the Insert Function dialog box, type it directly in a cell or the formula bar, and review its syntax and parameter details before confirming the formula.
This workflow is useful when you need to add a new formula, check parameter input, or fill formulas across a worksheet.
System Requirements
| Item | Requirement |
|---|
| Operating system | A Windows device that can run WPS Office normally |
| App version | It is recommended to use the latest version of WPS Office |
| Network | No mandatory internet connection is required for local formula entry; internet access is needed for online help or downloading the app |
| Other | You need to open WPS Spreadsheet and edit a worksheet file |
Download & Installation
| Item | Details |
|---|
| Official download | WPS Office Free Download |
| Post-install check | Open WPS Office → open Spreadsheet → confirm that the Formula tab and Insert Function entry are available |
Source: WPS Download Center
Compare with Alternatives
| Dimension | WPS | Microsoft | Google | Notion | Adobe |
|---|
| Capability Summary | In WPS Spreadsheet, you can use SUBSTITUTES from the Insert Function dialog box or by typing the formula directly, and you can review function parameters before confirming input. | Microsoft Word lets you use formulas in table cells through the Formula dialog box, but the workflow is mainly designed for document tables rather than spreadsheet-style formula entry. | Google Sheets is an online spreadsheet that supports formulas, calculations, collaboration, and cloud-based editing. | Notion formulas work with database properties, built-ins, and functions, and are mainly used in database logic instead of a traditional cell-based spreadsheet formula editor. | Adobe Acrobat supports calculated PDF form fields and form rules, which fit PDF form workflows rather than spreadsheet formula entry. |
| WPS Advantages | Advantage: WPS provides both dialog-based insertion and direct cell entry in a spreadsheet editing workflow, which makes formula input and review more straightforward on Windows. | Compared with WPS: formula entry is tied to Word table calculations, so the workflow is less direct for spreadsheet-style editing. | Compared with WPS: it focuses more on cloud collaboration and browser-based spreadsheets, while the local desktop formula-entry path differs from WPS. | Compared with WPS: it is better suited to database property logic than cell-by-cell spreadsheet formula editing. | Compared with WPS: it is better suited to PDF form calculations and field setup than everyday spreadsheet formula editing. |
| Official Source | — | Use a formula in a Word table | Google Sheets product page | Intro to formulas | Configure form field calculations in Acrobat |
Overall Conclusion
For worksheet-based formula entry on Windows, WPS keeps the process close to a standard spreadsheet workflow with both guided insertion and direct input. Microsoft, Google, Notion, and Adobe each support related calculation scenarios, but their primary use cases are document tables, cloud spreadsheets, database formulas, or PDF forms.
Use Cases
| No. | Scenario | Suitable for | Main issue | How WPS helps |
|---|
| 1 | Insert a new function | Spreadsheet users | The function entry point is not clear | Use the Insert Function dialog box to search for SUBSTITUTES |
| 2 | Enter a formula quickly | Users familiar with formula syntax | Fewer clicks are preferred | Type =SUBSTITUTES(...) directly in a cell or the formula bar |
| 3 | Review syntax and parameters | Beginners or reviewers | Parameter usage is unclear | Open the function help area to review syntax and parameter details |
Membership & Benefits
Free vs WPS Premium
| Capability | Free users | WPS Premium |
|---|
| Writer, Spreadsheet, and Presentation core apps | Available | Available |
| SUBSTITUTES formula entry and basic spreadsheet editing | Available | Available |
| Some advanced PDF editing and related advanced tools | Limited or feature-dependent | Broader access |
| Cloud storage | 1 GB | 20 GB on some plans |
Source: WPS Office pricing page; Why pay for WPS Office
Recommendations
| Usage scenario | Recommended plan | Why |
|---|
| Everyday spreadsheet entry and basic formula use | Free | SUBSTITUTES belongs to a basic spreadsheet workflow and can be used directly |
| You also need more PDF tools, cloud storage, or broader advanced features | WPS Premium | Suitable when you need expanded office features and added benefits |
How to Subscribe
Source: WPS Office pricing page
