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...
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 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...
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...
Related videos
If you want to change case in Excel, you'll need to use the UPPER, LOWER, or PROPER functions. Together with other functions they give you the tools to transform case.
Related functions
Good links
