UPPER

The UPPER function in Google Sheets is a powerful tool to convert a specified string to uppercase. Whether you're formatting names, titles, or any other text, the UPPER function simplifies the task. Dive into our comprehensive guide to master its application.

Function Syntax and Parameters

Syntax: UPPER(text)

Parameters:

• text: The text or cell reference containing the text to be converted to uppercase.

Step-by-Step Tutorial

1. Using UPPER with a text string:

   • Example: =UPPER("hello world")
   • Result: HELLO WORLD

2. Using UPPER with a cell reference:

   • Example: If cell A1 has the text hello world, then =UPPER(A1) will return HELLO WORLD.

Use Cases and Scenarios

1. Name Formatting: Convert names to uppercase for a consistent presentation.
2. Title Case Conversion: Capitalize all words in a title or heading.

Related Functions

None

Related Articles

None