MID in WPS on Windows: Introduction

WPS MID is a text extraction function used in formula fields in multi-dimensional tables; it includes 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
Version recommendation	Use the latest WPS Office	Helps provide a stable multi-dimensional table and formula editing experience

About This Feature

Overview

MID is a text function in WPS Office on Windows for multi-dimensional tables. It helps with text extraction in formula fields by returning a specified number of characters from the middle of a string. You can use it directly in a formula field and combine it with functions such as IF and AND for tasks like code splitting, ID information extraction, and text cleanup.

Core capabilities include:

Entering a MID formula in a formula field and getting results immediately.
Setting the start position and extraction length with the required parameter format.
Combining MID with other functions for more complex text processing in business tables.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office normally
App version	The latest WPS Office version is recommended
Network	No mandatory network connection is required for local formula editing; downloading, signing in, or syncing requires internet access
Other	You need access to open the multi-dimensional table and permission to add or edit formula fields

Download & Installation

Before using MID, install WPS Office on your Windows device and open the multi-dimensional table formula editor.

Item	Details
Official download	WPS Office Free Download
Check after installation	Launch WPS Office, open a multi-dimensional table, and confirm that Add Field and Formula are available

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Uses MID in a formula field inside a multi-dimensional table to extract a fixed-length text segment from the middle of a string, with support for nested formulas.	Excel provides the `MID(text, start_num, num_chars)` syntax to return a text segment based on a start position and length.	Google Sheets provides the `MID(string, starting_at, extract_length)` syntax to return part of a string.	Notion formulas use `substring` to extract text with start and end indexes instead of a MID function name.	Acrobat focuses on PDF text editing and export rather than spreadsheet-style MID formula functions.
WPS Advantages	Advantage: Works directly in formula fields in multi-dimensional tables for ongoing record-based calculation; Distinct: fits business-table workflows where multiple formulas are used together.	Compared with WPS: offers a mature MID formula syntax, but it is mainly designed for spreadsheet cells.	Compared with WPS: offers a similar MID syntax and is commonly used in online spreadsheets.	Compared with WPS: requires a substring-based approach, so MID-style formulas usually need to be rewritten.	Compared with WPS: is better suited to PDF text handling and is not a direct replacement for formula fields in multi-dimensional tables.
Official Source	—	Excel MID function	Google Sheets MID	Notion formula syntax	Edit text in PDFs in Acrobat

Overall Conclusion: If your main work involves field calculation and text splitting inside a multi-dimensional table, WPS MID is closer to that workflow. Excel and Google Sheets provide similar functions in traditional spreadsheets, Notion uses a different substring model, and Adobe Acrobat is not a comparable formula-processing tool.

Use Cases

No.	Scenario	Suitable users	Main pain point	How MID helps
1	Code splitting	Operations, sales, and admin teams	Only one middle segment is needed from a long code	Use MID in a formula field to extract the required character range
2	ID information extraction	HR and registration staff	A birth year or gender marker needs to be extracted from an ID number	Combine MID with other functions to split the field content
3	Text cleanup	Data processing staff	Raw text is inconsistent and manual cleanup is slow	Use a formula field to extract text from fixed positions automatically
4	Auto-calculation after import	Table maintainers	Imported data still needs repeated manual text handling	Let the formula field refresh results automatically as records update
5	Combined logic checks	Business analysts	The extracted text still needs to be used in logic conditions	Use MID output as input for IF, AND, and similar functions

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
Basic MID formula usage	✅ Available	✅ Available
Formula field calculation in multi-dimensional tables	✅ Available	✅ Available
Other premium office benefits	Availability depends on the account plan shown	Includes additional membership-related office benefits

Source: WPS Office pricing page

Recommendations

Scenario	Recommended plan	Why
Daily text extraction and light data cleanup	Free	Basic MID usage has no membership restriction and fits routine formula work
Formula work plus broader premium office needs	WPS Premium	Suitable when you also need additional premium office services beyond formula processing

WPS membership center: Subscribe now