LOWER in WPS on Windows: Introduction

LOWER in WPS is a text function for converting text to lowercase in Bitable; 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

About This Feature

Overview

The LOWER function in WPS Bitable converts letters in text to lowercase. It can be used in a formula field and combined with other functions for text normalization, field cleanup, and consistent output formatting.

Core capabilities include:

Use LOWER in a formula field to process text.
Fill in the function with the required parameter format.
Combine LOWER with other functions for more complex text workflows.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office
App version	It is recommended to use the latest version of WPS Office
Network	Local formula editing usually does not require a constant connection; sign-in, sync, or collaboration features may require internet access
Other	You need access to Bitable and permission to edit fields or formulas

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Office, enter Bitable, and confirm that you can add a Formula field

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Use LOWER in a Bitable formula field to convert text to lowercase and combine it with other functions.	Excel provides the LOWER(text) function to convert uppercase letters in a text string to lowercase.	Google Sheets provides the LOWER(text) function to convert a specified string to lowercase.	Notion database formulas support lower() for converting text to lowercase, mainly in database property calculations.	Adobe Acrobat focuses on editing and formatting text in PDFs rather than providing a spreadsheet-style LOWER function.
WPS Advantages	Advantage: LOWER works directly in Bitable formula fields, which helps keep field-based records normalized as table data changes.	Compared with WPS: LOWER is documented for spreadsheet cell formulas; field-based database workflows are organized differently.	Compared with WPS: LOWER fits spreadsheet cell formulas, while WPS centers this use in a Bitable field workflow.	Compared with WPS: lower() is available, but it belongs to a database formula system rather than a spreadsheet-style function set.	Compared with WPS: Acrobat is designed for PDF text editing and does not provide a directly equivalent table function entry point.
Official Source	—	Excel LOWER function	Google Sheets LOWER	Notion formula syntax	Adobe Acrobat edit text in PDFs

Overall Conclusion
If your work focuses on field-based calculations and text normalization inside a table workflow, LOWER in WPS is a practical fit. Excel and Google Sheets document the same lowercase conversion in spreadsheet cells, Notion supports a database-formula version, and Adobe Acrobat is aimed at PDF text editing instead of table formulas.

Use Cases

No.	Scenario	Suitable For	Pain Point	How LOWER Helps
1	Standardize imported text	Data organizers	Imported records use inconsistent letter case	Convert text to lowercase in a formula field
2	Build combined text workflows	Table builders	One text step is not enough for business rules	Nest LOWER with other functions
3	Keep field output consistent	Team collaborators	Multi-user input creates inconsistent formatting	Output a unified lowercase result automatically
4	Reuse table templates	Team admins	Repeating text cleanup setup takes time	Preset LOWER in reusable formula fields
5	Support filtering and comparison	Operations or analysts	Case differences affect matching results	Normalize text before later checks or combinations

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
Use the LOWER function	✅ Available	✅ Available
Create formula fields	✅ Available	✅ Available
Other premium benefits	Refer to the current account benefits page	Refer to the current account benefits page

Source: WPS Office pricing page

Recommendations

Scenario	Recommended Plan	Why
Everyday lowercase conversion and basic table cleanup	Free	LOWER can be used directly for common text normalization tasks
Broader cross-feature work or added service needs	WPS Premium	Suitable for users or teams that also need additional premium benefits

WPS membership center: Subscribe now