Excel UPPER Function
Summary
The Excel UPPER function returns a upper-case version of a given text string. Numbers and punctuation are not affected.
Purpose
Convert text to upper case
Return value
Uppercase text.
Syntax
=UPPER (text)
Arguments
- text - The text thatto convert to upper case.
Usage notes
- All letters in text are converted to upper case.
- Numbers and punctuation characters are not affected.
UPPER formula examples
To count how many times a specific character appears in a cell, you can use a formula based on the SUBSTITUTE and LEN functions. In the generic form of the formula above, A1 represents the cell address, and "a"...
If you need to count specific characters in a range of cells, you can do so with a formula that uses LEN and SUBSTITUTE, along with the SUMPRODUCT function. In the generic form of the formula (above), rng represents a...
If you need to count how many times a specific a word (or any substring) appears inside a cell, you can use a formula that uses SUBSTITUTE and LEN. In the generic form of the formula above, a1 represents a cell that...
To count how many times a specific a word (or any substring) appears inside a range of cells, you can use a formula based on the SUBSTITUTE, LEN, and SUMPRODUCT functions. In the example shown, the formula in C11 is...
To allow a user to enter only uppercase TEXT, you can use data validation with a custom formula based on the UPPER, EXACT, and AND functions.
In the example shown, the data validation applied to C5:C7 is:
=AND(EXACT...
Related videos
In this video, we show how to use the UPPER, LOWER, and PROPER functions to transform case with a formula.
Related functions
Good links
