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.
Version
Usage notes
- All letters in text are converted to upper case.
- Numbers and punctuation characters are not affected.
UPPER formula examples
Data validation rules are triggered when a user adds or changes a cell value.
The UPPER function changes text values to uppercase, and the EXACT function performs a case-sensitive comparison.
The AND function takes...
For each cell in the range, SUBSTITUTE removes all the o's from the text, then LEN calculates the length of the text without o's. This number is then subtracted from the length of the text with o's.
Because we are...
This formula works by using SUBSTITUTE to first remove all of the characters being counted in the source text. Then the length of the text (with the character removed) is subtracted from the length of the original text...
B4 is the cell we're counting words in, and C4 contains the substring (word or any substring) you are counting.
SUBSTITUTE removes the substring from the original text and LEN calculates the length of the text without...
In the generic version of the formula, rng represents the range to check, and txt is the word or substring to count.
In the example shown, B5:B8 is the range to check, and C2 contains the text (word or substring) to...
Related videos
In this video, we show how to use the UPPER, LOWER, and PROPER functions to transform case with a formula.
Related functions
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.
