Knowledge base / Excel
Excel LOWER: text comparisons, spaces and name fragments
I show case conversion, jamsmith from three first-name characters and a surname, and the distinction between comparison and normalization.

LOWER converts uppercase letters in text to lowercase. Its Polish name is LITERY.MAŁE. The order matters: reversing the Polish name does not produce a valid substitute for that function.
I use this conversion in a helper column when the agreed data rule allows case to be ignored. I do not assume that every code, username or address can be freely rewritten. I preserve the source and check whether the transformation removes a distinction that the receiving system needs.
Syntax and availability
=LOWER(A2)
In Polish Excel, use =LITERY.MAŁE(A2). The function has one required argument. You can reference a cell or supply a string in double quotation marks. This one-argument form has no argument separator, although separators matter in some combinations of functions.
Microsoft documents LOWER for Microsoft 365 and Excel 2024, 2021, 2019 and 2016. Non-letter characters remain in the string. The operation is not restricted to uppercase letters from the English alphabet.
Examples that show the scope of conversion
Place these synthetic strings in A2:A5 and fill the formula down from B2.
| Row | Text in A | Result in B |
|---|---|---|
| 2 | EXCEL | excel |
| 3 | ŁÓDŹ | łódź |
| 4 | ÉÇ | éç |
| 5 | Ab-12! | ab-12! |
The third and fourth rows also convert accented letters. In the last row, digits, the hyphen and the exclamation mark remain unchanged. This is case conversion without accent removal or replacement of separating characters.
AB-12 and ab-12 produce the same form. Do not automatically infer that their records represent the same product. The source definition of the code must establish that rule. LOWER does not recognize entities or verify uniqueness.
Combining a first name and surname
Suppose A2 contains James and B2 contains Smith. In this synthetic example, I want the first three characters of the first name followed by the entire surname, without a space.
=LOWER(LEFT(A2,3)&B2)
In Polish Excel, use =LITERY.MAŁE(LEWY(A2;3)&B2). LEFT selects Jam, the ampersand adds Smith, and LOWER returns jamsmith. Keeping the entire first name needs a different expression: =LOWER(A2&B2) gives jamessmith.
This demonstrates string construction rather than a complete username policy. Two people can produce the same result. A real process needs rules for collisions, exceptions and allowed characters. Combining name fragments does not establish a stable identifier by itself.
Comparing case-sensitive text
To check exact text spelling, use EXACT, called PORÓWNAJ in Polish. It distinguishes letter case while ignoring differences in cell formatting.
=EXACT("Ab","ab")
The result is FALSE. Lowercasing both arguments first would remove the very difference you were trying to detect. That normalization is appropriate only when the comparison specification allows case differences to be ignored.
I separate the original column from a comparison column. A recipient may need both an approved display name and a standardized helper form. One should not silently replace the other. Remember that spaces can still differ after using LOWER.

Spaces and input data
For extra ordinary spaces, this combination is useful:
=LOWER(TRIM(A2))
Its Polish form is =LITERY.MAŁE(USUŃ.ZBĘDNE.ODSTĘPY(A2)). The documented Polish name of TRIM is USUŃ.ZBĘDNE.ODSTĘPY. Microsoft explains that TRIM alone does not remove nonbreaking spaces with code 160. Avoid promising that it completely cleans every imported string.
LOWER produces text. These examples supply strings, and the digits inside a code remain characters in that string. I do not use case conversion as a way to preserve a numeric column for calculations. I keep the original numbers in a separate column.
Establish a separate missing-value policy so an empty result is not mistaken for evidence of valid data. When a source contains an error, identify its cause instead of hiding every problem behind an empty string. Changing letter case is not a repair process for invalid input data.
Finishing the task and an exercise
After reviewing the helper column, copy the output and paste values only. Microsoft demonstrates this case-conversion workflow. Retain the source until the destination form has been checked against its requirements.
For practice, compare Ab-12, AB-12 and AB 12. Lowercase all three, but assess equality separately. The first two outputs become identical. The third keeps a space rather than a hyphen. Then consider two synthetic people, Alice Smith and Alina Smith: three first-name characters followed by the full surname produce alismith in both cases. Describe the method’s limitation.
For uppercase output, see UPPER. For capitals at separator boundaries, see PROPER. None of these functions can automatically recover an original mixed-case spelling after it has been discarded.
Key takeaways
What is the Polish name of LOWER?
It is LITERY.MAŁE. Reversing the words produces an incorrect function name.
Does LOWER skip accented letters?
No. It also converts accented letters, for example ŁÓDŹ to łódź, without removing their accents.
Does LOWER generate a unique username?
No. Different people or codes can produce the same result. Collision handling requires a separate rule.
AI was used in an automated way while working on this article. If you want to learn how to do it too, check out this project.
