LOWER in WPS on Windows: Introduction

LOWER in WPS on Windows is a text function in WPS Office Sheets that converts uppercase letters in text to lowercase; it includes 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
Version limits	None	Available in WPS Office Sheets on Windows

About This Feature

Overview

LOWER in WPS Office Sheets on Windows is a built-in text function for converting uppercase letters in a text string to lowercase. It is useful for text cleanup, imported data normalization, and batch formatting in spreadsheets.

Core capabilities:

Convert uppercase letters in text to lowercase for names, labels, notes, and other text fields.
Enter the function directly in a cell or in the formula bar for quick calculation.
Use syntax prompts and automatic recalculation when referenced data changes.

This feature fits spreadsheet text cleanup, formatting consistency, and batch data preparation. It helps reduce manual case editing and supports formula-based text processing in WPS Office.

System Requirements

Item	Requirement
OS	A Windows device that can run WPS Office
App version	The latest version of WPS Office is recommended; LOWER is available in WPS Office Sheets on Windows
Network	No required network connection for local spreadsheet function use
Other	You need to open and edit a spreadsheet file and enter formulas in cells

Download & Installation

Before you use the LOWER function, install WPS Office on your Windows device and open WPS Office Sheets.

Item	Notes
Official Download	WPS Office Free Download
Post-install Check	Launch WPS Office, open Sheets, select any cell, and enter `=LOWER(`

Source: WPS Office Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	LOWER converts uppercase letters in text to lowercase in spreadsheet cells and updates results when referenced data changes.	Excel LOWER(text) converts all uppercase letters in a text string to lowercase and does not change non-letter characters.	Google Sheets LOWER(text) converts a specified string to lowercase.	Notion formulas support `lower()` to convert text to lowercase in database formulas.	Acrobat Desktop Help focuses on PDF viewing, editing, conversion, and page tools, and its help center does not present a spreadsheet LOWER function counterpart.
WPS Advantages	Advantage: WPS uses a familiar spreadsheet formula workflow with direct cell entry, syntax prompts, and automatic recalculation for text cleanup on Windows.	Compared with WPS: Microsoft provides an equivalent LOWER function and documents the syntax and examples clearly.	Compared with WPS: Google provides an equivalent LOWER function for browser-based spreadsheet workflows.	Compared with WPS: Notion supports lowercase conversion in database formulas, but the workflow is centered on database properties rather than spreadsheet cells.	Compared with WPS: Adobe's official desktop help is centered on PDF workflows instead of spreadsheet text functions.
Official Source	—	LOWER function	LOWER	Formula syntax and functions	Acrobat Desktop Help

Overall Conclusion: For spreadsheet text normalization on Windows, WPS LOWER provides a direct formula workflow inside WPS Office Sheets. Microsoft Excel and Google Sheets offer equivalent lowercase functions, Notion applies lowercase conversion in database formulas, and Adobe Acrobat focuses on PDF tasks rather than spreadsheet formulas.

Use Cases

#	Scenario	Target Users	Core Pain Point	Solution
1	Standardize customer lists	Admin teams, sales teams, operations teams	Imported names or email fields use inconsistent letter case	Use LOWER to convert the target text column to lowercase
2	Clean up tag fields	Data coordinators	Mixed uppercase and lowercase tags make filtering harder	Apply LOWER to the tag column before filtering or counting
3	Prepare text before comparison	Finance users, analysts	Text values are not normalized before comparison	Convert text with LOWER before combining it with other formulas
4	Organize imported data in batches	Students, teachers, office users	External data arrives with inconsistent text formatting	Use LOWER in a helper column to generate normalized text
5	Combine with other formulas	Advanced spreadsheet users	One function alone is not enough for text processing	Nest LOWER with other text functions in the same formula

Membership & Benefits

Free vs WPS Premium

Feature	Free User	WPS Member
LOWER function	✅ Available	✅ Available
Basic spreadsheet editing	✅ Available	✅ Available
Additional advanced benefits	Depends on the current account plan	Includes more advanced features and extended services

Source: WPS Office pricing page

Recommendations

Use Case	Recommended Plan	Reason
Everyday lowercase conversion and basic spreadsheet cleanup	Free	LOWER itself has no membership restriction
Spreadsheet work plus broader advanced office needs	WPS Premium	Suitable if you also need more advanced features beyond this function

Membership page: Subscribe to WPS Premium