LOWER in WPS on Windows: Introduction

WPS LOWER is a text function in WPS Spreadsheet that converts a specified string to lowercase; this guide covers 1 core task, with 1 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	1	Matches the number of rows in the How-to Index
Available without membership	1	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 Spreadsheet converts text to lowercase, which is useful for cleaning imported data, standardizing text fields, and keeping letter case consistent across a worksheet.

Core capabilities:

Convert constant text to lowercase for quick formula testing.
Convert text from a cell reference for batch cleanup.
Show syntax prompts while you type the formula.
Update results automatically when referenced cell values change.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office normally
App version	The latest version of WPS Office is recommended
Network	No mandatory network connection for local formula calculation; internet is needed for download, installation, or account-related actions
Other	You need access to WPS Spreadsheet and permission to edit cells

Download & Installation

Item	Details
Official download	WPS Office Free Download
Post-install check	Open WPS Office, launch WPS Spreadsheet, and confirm that you can enter `=LOWER()` in a cell

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Uses `LOWER(text)` in WPS Spreadsheet to convert text to lowercase with formula syntax prompts during input.	Word provides a Change Case command that can convert selected text to lowercase, but it is not a spreadsheet formula.	Google Sheets provides `LOWER(text)` to convert a specified string to lowercase.	Notion formulas support `lower()` to convert text to lowercase in database formulas.	Acrobat help focuses on PDF text editing and does not present an equivalent spreadsheet LOWER function.
WPS Advantages	Advantage: It works directly in spreadsheet cells and fits naturally into formula-based data cleanup workflows.	Compared with WPS: focused on document text formatting rather than cell-based formula calculation.	Compared with WPS: offers a similar lowercase function with comparable formula usage.	Compared with WPS: useful in database formula workflows, but not in a traditional spreadsheet cell grid.	Compared with WPS: centered on PDF editing rather than spreadsheet text functions.
Official Source	—	Change case	LOWER	Formula syntax & functions	Acrobat Desktop Help

Overall Conclusion: For spreadsheet-based text normalization on Windows, WPS LOWER fits directly into cell formulas and routine data cleanup. Google Sheets and Notion provide related lowercase functions in their own environments, while Microsoft Word and Adobe Acrobat focus more on document or PDF text handling.

Use Cases

No.	Scenario	Suitable for	Pain point	Solution
1	Cleaning imported lists	HR teams, admins	Names or email addresses use inconsistent letter case	Enter `=LOWER(A2)` in a helper column
2	Standardizing account fields	Operations, data teams	User IDs or labels are mixed in case	Use LOWER to generate consistent lowercase output
3	Combining text formulas	Spreadsheet power users	Need to chain text functions together	Use LOWER with lookup, join, or other formulas
4	Teaching formula basics	Trainers, teachers	Need a simple text-function example	Demonstrate `=LOWER("TEXT")` in class
5	Daily worksheet review	General office users	Manual lowercase editing takes too long	Let the formula return standardized text automatically

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
Basic LOWER function usage	✅	✅
Basic spreadsheet editing	✅	✅
Additional advanced benefits	Available within the free offering shown on the pricing page	Includes broader benefits and capacity shown on the pricing page

Source: WPS Office pricing page

Recommendations

Scenario	Recommended plan	Why
You mainly need LOWER and other basic formulas	Free	It is enough for everyday lowercase text conversion
You also need more cloud space or broader advanced features	WPS Premium	Better for users with wider productivity needs across features

WPS membership center: Subscribe to WPS Premium