Table of Contents
The UPPER function in Google Sheets is a tool that allows users to convert text to all uppercase letters. This can be useful in cases where all text needs to be capitalized, such as in a title or heading. To use the function, simply type “=UPPER(” in a cell followed by the text you want to convert, and close the parentheses. The function will automatically convert the text to uppercase letters. It is a quick and efficient way to change the case of text in a Google Sheets spreadsheet.
UPPER function
Converts a specified string to uppercase.
Sample Usage
UPPER("lorem ipsum")
UPPER(A2)
Syntax
UPPER(text)
text– The string to convert to uppercase.
See Also
PROPER: Capitalizes each word in a specified string.
LOWER: Converts a specified string to lowercase.
Examples
[wpcc-iframe height=”300″ src=”https://docs.google.com/spreadsheet/pub?key=0As3tAuweYU9QdExqajg1MS1xSjdoN3NfMTFqR1hwa2c&output=html” width=”500″]
Cite this article
stats writer (2024). How can I use the UPPER function in Google Sheets to convert text to all uppercase letters?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-use-the-upper-function-in-google-sheets-to-convert-text-to-all-uppercase-letters/
stats writer. "How can I use the UPPER function in Google Sheets to convert text to all uppercase letters?." PSYCHOLOGICAL SCALES, 1 Jul. 2024, https://scales.arabpsychology.com/stats/how-can-i-use-the-upper-function-in-google-sheets-to-convert-text-to-all-uppercase-letters/.
stats writer. "How can I use the UPPER function in Google Sheets to convert text to all uppercase letters?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-use-the-upper-function-in-google-sheets-to-convert-text-to-all-uppercase-letters/.
stats writer (2024) 'How can I use the UPPER function in Google Sheets to convert text to all uppercase letters?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-use-the-upper-function-in-google-sheets-to-convert-text-to-all-uppercase-letters/.
[1] stats writer, "How can I use the UPPER function in Google Sheets to convert text to all uppercase letters?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, July, 2024.
stats writer. How can I use the UPPER function in Google Sheets to convert text to all uppercase letters?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.