How To:

Transform Text Case in Microsoft Excel, Apple Numbers and Google Spreadsheet

If you work with spreadsheets, you may find yourself needing to change the case of your text from time to time, and this online case converter can help! Whether you want to make your text uppercase, lowercase, or proper case, it can be a tedious process to do it manually. Fortunately, most spreadsheet programs come with tools that make it easy to change the case of your text, and in this tutorial, we'll show you how to do it in Microsoft Excel, Apple Numbers, and Google Sheets.

Microsoft Excel:

Microsoft Excel comes with several functions that make it easy to change the case of your text. Here's how to do it:

1. Open your spreadsheet in Microsoft Excel.
2. Select the cell or cells that contain the text you want to change.
3. On the ribbon, click the Formulas tab.
4. In the Text group, click the button for the function you want to use: UPPER, LOWER, or PROPER.
5. In the Function Arguments dialog box, type the cell reference or text string in the Text box.
6. Click OK to apply the function and change the case of the text.

Here's an example using the UPPER function:

1. Select the cell that contains the text you want to change.
2. On the ribbon, click the Formulas tab.
3. In the Text group, click the UPPER button.
4. In the Function Arguments dialog box, type the cell reference or text string in the Text box.
5. Click OK to apply the function and change the text to uppercase.

You can use the same steps with the LOWER or PROPER functions to change the text to lowercase or proper case, respectively.

Apple Numbers:

Apple Numbers, the spreadsheet program included with macOS and iOS, also offers several tools for changing the case of your text. Here's how to do it:

1. Open your spreadsheet in Apple Numbers.
2. Select the cell or cells that contain the text you want to change.
3. On the Format menu, click the Cell tab.
4. In the Data Format section, click the drop-down menu for the Case option.
5. From the drop-down menu, select the case you want to apply to your text. You can choose from UPPERCASE, lowercase, and Proper Case.
6. The selected text will be changed to the case you selected.

Alternatively, you can use the following keyboard shortcut to change the case of your text:

• tOGGLE cASE: Command+Shift+X

Google Sheets:

Google Sheets, the free online spreadsheet program from Google, also has several tools for changing the case of your text. Here's how to do it:

1. Open your spreadsheet in Google Sheets.
2. Select the cell or cells that contain the text you want to change.
3. On the toolbar, click the Format tab.
4. In the Text group, click the UPPER, LOWER, or PROPER button.
5. The selected text will be changed to the case you selected.

Note: Shortcut keys may vary depending on your operating system and the version of the word processor you are using.