The formula used to change a small word (lowercase text) to a capital word (uppercase text) is the UPPER function.
Using the UPPER Function
The UPPER function is commonly used in spreadsheet applications like Microsoft Excel, Google Sheets, and other similar programs. It converts all lowercase letters in a text string to uppercase letters.
Syntax:
UPPER(text)Where text is the cell reference or the text string you want to convert to uppercase.
Example:
If you have the word "hello" in cell A1, the formula =UPPER(A1) would return "HELLO".
Step-by-Step Guide:
- Select the cell where you want the uppercase result to appear.
- Enter the formula
=UPPER(A2)(replaceA2with the cell containing the lowercase text). - Press Enter. The cell will now display the uppercase version of the text from the referenced cell.
- Fill Down (Optional): If you have a column of lowercase words, you can drag the fill handle (the small square at the bottom-right corner of the cell) down to apply the formula to other cells in the column. This will convert all the words in that column to uppercase.
Example in Microsoft Excel/Google Sheets:
| Cell | Content | Formula | Result |
|---|---|---|---|
| A1 | hello | ||
| B1 | =UPPER(A1) |
HELLO | |
| A2 | world | ||
| B2 | =UPPER(A2) |
WORLD | |
| A3 | example text | ||
| B3 | =UPPER(A3) |
EXAMPLE TEXT |
The UPPER function is a simple and effective way to convert text to uppercase in spreadsheet applications.
