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.

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