Excels UPPER function has your back.
Syntax:
This function takes one argumentthe text you want to convert.
you’ve got the option to reference a cell or input the text directly into the formula.
Imagine you’re preparing a mailing list with all the customer names in lowercase.
The format the email labels use is upper case.
With UPPER, it’s possible for you to quickly turn john doe into JOHN DOE.
When converting entire ranges to upper case, you canuse an array formulafor efficiency.
This function works the same way as UPPER.
Feed it a cell reference or text string, and Excel will handle the rest.
This is particularly useful when standardizing text across multiple records.
If the original text becomes redundant,hide the columnor move it to another sheet to keep things clean.
Just like its case-changing cousins, PROPER needs only the text to convert.
Its especially useful when dealing with names, titles, or anything that requires a neat and professional look.
Heres what each of these functions does:
LEFT
Returns characters from the start of the string.
RIGHT
Returns characters from the end of the string.
LEN
Counts the number of characters in a text string.
UPPER
Converts text to upper case.
LOWER
Converts text to lower case.
This may seem overwhelming but don’t worry.
The formula is quite easy to grasp once you understand the purpose of each function.
First, it converts the first letter of the text in cellA2to upper case using theLEFTandUPPERfunctions.
After all, the whole point of Excel is to make your life easierso let it.
