Knowledge base / Excel
Excel UPPER: uppercase codes and combined text
I show uppercase code conversion, joining fields with a space and the risk of collapsing distinct identifiers.

You need an export whose codes use uppercase letters. The source contains ab-12, Ab-12 and AB-12. English Excel provides UPPER; its Polish name is LITERY.WIELKIE. Reversing the Polish name’s words does not produce a valid function name.
First I establish whether case may be standardized. If the receiving system distinguishes two such codes, conversion can destroy meaningful information. When uppercase is an agreed export rule, a simple helper column is sufficient to prepare it.
Syntax and Excel versions
=UPPER(A2)
In Polish Excel, use =LITERY.WIELKIE(A2). The argument can be a reference to text or a string in double quotation marks. A one-argument expression has no argument separator to translate between commas and semicolons.
Microsoft documents UPPER as a text conversion function and lists Microsoft 365 plus Excel 2024, 2021, 2019 and 2016. It does not require newer dynamic-array functions. Keep the simple syntax while deciding what the transformed column should mean.
A small code example
These values are synthetic. Put them in A2:A5, enter the formula in B2 and fill down. The result stays beside the source.
| Row | Text in A | Result in B |
|---|---|---|
| 2 | ab-12 | AB-12 |
| 3 | Ab-12 | AB-12 |
| 4 | łódź | ŁÓDŹ |
| 5 | part 7! | PART 7! |
Letters change case, while the hyphen, digits, space and exclamation mark remain in the string. The Polish example in Microsoft’s UPPER documentation also demonstrates accented letters. This operation does not remove Polish characters or transliterate them into ASCII.
The first two codes produce the same output. UPPER does not establish uniqueness or automatically create identifiers. If the transformed column must be a unique key, separately check whether different source forms have collapsed into the same result.
Joining two fields with a space
Suppose A2 contains Jan and B2 contains Kowalski. I want one string, JAN KOWALSKI.
=UPPER(A2&" "&B2)
The Polish equivalent is =LITERY.WIELKIE(A2&" "&B2). The ampersand first combines the name, an explicit space and the surname. UPPER converts the combined text. Without " ", the parts would run together. The space inside quotation marks is actual data.
For longer lists with a delimiter, see TEXTJOIN. Do not assign delimiter and ignore-empty arguments to CONCATENATE, which is a different function. The simple ampersand example avoids mixing their signatures.

Spaces and cell appearance
UPPER does not remove extra spaces. To handle ordinary spaces at the same time, combine it with TRIM:
=UPPER(TRIM(A2))
In Polish Excel, use =LITERY.WIELKIE(USUŃ.ZBĘDNE.ODSTĘPY(A2)). TRIM handles ordinary spaces with character code 32. It does not remove nonbreaking spaces with code 160 on its own, which matters when values were copied from web pages.
Case conversion returns new text rather than changing the source cell’s font setting. It does not change color, bold formatting or column width. I keep numbers needed for later calculations in their numeric columns. Digits remaining within a string do not mean that the output of a text function preserves the original numeric type.
When I preserve the original
I would not automatically convert passwords, technical tokens or identifiers whose case matters. The requirements of the specific receiving system determine whether conversion is valid. A uniform appearance is not proof that the exported values still work.
Brand names can also contain intentional capitalization. If a report needs uppercase headings, I can prepare a separate display column while retaining the source name and object key. A presentation transformation then avoids becoming an irreversible change to the underlying reference data.
If you need initial capitals at word boundaries, see PROPER. For all lowercase letters, use LOWER. Lowercasing an uppercase output will not reconstruct its original mixed case.
Saving the result and an exercise
Microsoft demonstrates the helper-column and paste-values workflow. After reviewing the outputs, copy them and choose to paste values only. Before deleting a source column, verify the destination range and whether those formulas were the only retained link to the original.
For practice, prepare ab-12, AB-12 and ab 12. Predict the output for each code. The first two become identical. The third retains its space rather than gaining a hyphen. Letter case is only one attribute of the data; converting it does not prove that all three strings describe the same product.
Key takeaways
What is the Polish name of UPPER?
It is LITERY.WIELKIE. Reversing the order of the words produces an incorrect name.
Does UPPER remove spaces?
No. TRIM handles extra ordinary spaces, while nonbreaking spaces can require another operation.
Does UPPER create a unique identifier?
No. Codes differing only in case can become identical. Uniqueness needs a separate check.
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.
