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
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...
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...
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 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"...
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
