You are handed a list of 2,000 customers with names in capitals, lowercase and random mixes, and must make it uniform before importing. You retype thirty and give up.
How to use Uppercase and Lowercase step by step
1. Choose the final style
All capitals, all lowercase, each word with a capital initial, or only the first letter of the text.
2. Give the cell and the spaces
Enter the source cell and decide whether extra spaces should also be removed with TRIM.
3. Copy, drag and paste as values
When the result looks right, copy the column and paste as values to cut the dependency on the formula.
The Step Count: Traditional Friction vs. KorexTools
Retyping or hunting for a shortcut (4 steps)
- Try Shift+F3 as in Word.
- Find out it does nothing in Excel.
- Try Flash Fill and see it stumble on compound names.
- End up retyping by hand.
With the KorexTools “Uppercase and Lowercase” builder (3 steps)
- Pick the final style.
- Type the source cell.
- Copy, drag and paste as values.
Excel has no uppercase button: what exists is three functions and one trick
UPPER turns everything into capitals, LOWER into lowercase, and PROPER capitalises the initial of each word. What is missing, and what people ask for most, is capitalising only the first letter of a text, sentence style. That is done by combining LEFT, MID and LEN, which hardly anyone remembers by heart.
The builder writes all four variants and, if you leave it on, wraps the text in TRIM to remove spaces at the start, at the end and doubled between words. It is the usual reason two names that look identical fail to match in a later lookup. Keep in mind that PROPER capitalises letters following an apostrophe, so "d'angelo" becomes "D'Angelo", but "mcdonald" becomes "Mcdonald".
When to use which text function
- •Codes or acronyms that must sit in block capitals: UPPER.
- •E-mails or tags that must be uniform: LOWER.
- •People’s or city names: PROPER, checking exceptions such as "de" or "van".
Four conversions of "juan PÉREZ"
| Function | Formula | Result |
|---|---|---|
| Uppercase | =UPPER(A2) | JUAN PÉREZ |
| Proper case | =PROPER(A2) | Juan Pérez |
| First letter only | =UPPER(LEFT(A2,1))&LOWER(MID(A2,2,LEN(A2))) | Juan pérez |
Common Mistakes and How to Avoid Them
- ⚠️Pasting the formula over the same source column and creating a circular reference.
- ⚠️Forgetting to paste as values and losing the text when deleting the original column.
Frequently Asked Questions
Is there a shortcut for uppercase without a formula?
Not in the spreadsheet. Word has Shift+F3, Excel does not. The no-formula alternative is Flash Fill (Ctrl+E), though it does not always guess right.
How do I keep the result as fixed text?
Copy the column holding the formula, paste as values and delete the original column. It then stops depending on the source cells.
Why does my list still not match another one even though it is now in capitals?
Invisible spaces remain. Keep the extra-space option on so TRIM removes them before converting.
What I would do if I were in your shoes
«Always convert into a new column and paste as values only after reviewing the result: deleting the source data first is a gamble.» — DataKorex Engineering Team.