LOWER in WPS Spreadsheet: Normalize Letter Case Without Changing the Source

• Introduced: documented by 2019-06-24 in the official WPS lesson; original introduction is not established.
• Availability: WPS Office for Windows Personal; numeric release not identified in the lesson. This is documentation evidence, not an installed-build guarantee.
• Scope: the exact supported build range is unverified. The cited Windows lesson does not establish equivalent availability in other WPS clients.
• Checked: October 14, 2026 against the function-specific lesson and vendor catalogue. Examples were independently calculated; no new native WPS test was performed.

=LOWER(text)

The single argument is a text string or cell reference. Put literal text in double quotes; use an unquoted address such as A2 when the text is stored in a cell. Enter the formula in a separate output column and press Enter.

The official lesson describes changing English letter case without changing non-letter characters. These examples deliberately use ASCII letters, digits and punctuation. Language-specific casing rules should be checked in the intended WPS locale before using this method for international identity fields.

Enter the following values in A2:A5, preserving the spaces shown inside the quoted examples. Do not type the surrounding explanatory quotes into the cells.

In B2 enter:

=LOWER(A2)

Fill B2 down to B5. The source column is unchanged, and a value that is already lowercase remains the same. This makes the helper column suitable for a consistent display or a case-normalized comparison field.

Do not overwrite the source immediately. A product key, username or other identifier may be intentionally case-sensitive even when a reporting convention prefers lowercase text.

Put the text NORTH DEPOT in D2, with two ordinary spaces at each end and between the words.

=LOWER(D2)

Expected result: north depot , with all original spaces preserved. LOWER changes letters, not spacing.

If the field’s rules also permit collapsing ordinary repeated spaces, use:

=LOWER(TRIM(D2))

Expected result: north depot. The TRIM guide explains that separate operation. Combining the two is appropriate only when both transformations are allowed; spaces can be meaningful in fixed-width data.

These literal tests make the boundaries visible:

LOWER is not a spelling correction or transliteration function. It will not repair a mistyped identifier, insert missing separators or decide whether two records refer to the same real item.

After producing B2 with =LOWER(A2), put this in C2 and fill down:

=IF(EXACT(A2,B2),"Already lowercase","Case changed")

For the four-row dataset, C2:C5 is Case changed, Case changed, Case changed, Already lowercase. EXACT is useful because it compares case-sensitive text rather than a visual impression of the cells.

Now compare two values after normalization:

=EXACT(LOWER("DEPOT-A"),LOWER("depot-a"))

Expected result: TRUE. Both sides become depot-a. This answers whether the strings match after the chosen case normalization; it does not prove that the original strings were exactly equal.

Keep the rule visible in a column heading such as “Lowercase comparison key.” Otherwise another reader may mistakenly treat the normalized value as the original spelling.

If the result still differs from the comparison target, inspect spaces and punctuation. LOWER does not remove a trailing blank or turn a hyphen into an underscore. Test with a short literal such as =LOWER("ABC") to distinguish a formula-entry problem from a source-data problem.

Avoid blindly lowercasing passwords, case-sensitive account IDs or paths. For an email-related workflow, follow the system’s own normalization rules rather than assuming every part of every address is interchangeable by case. Save the original values and verify the downstream lookup behavior before replacing a production field.

UPPER performs the opposite case conversion. EXACT tests a case-sensitive match, while LEN helps reveal unexpected extra characters. These solve separate problems; using all of them does not make an unvalidated identifier trustworthy.

• Official WPS LOWER lesson, published 2019-06-24 (Chinese; Windows Personal scope).
• WPS LOWER documentation catalogue.

The lesson establishes the function-specific behavior discussed here. The catalogue confirms its listed identity, not an exact current build range. Expected outputs use original examples checked independently; native execution and broader client compatibility remain unverified.