USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Proofing
|
|
|
Formulas
|
|
|
Spell Check
|
|
|
The Review tab
|
Detailed explanation-1: -Select the “Formulas” tab > Select the “Text” drop-down list in the “Function Library” group. Select “LOWER” for lowercase and “UPPER” for uppercase. Next to the “Text” field, click the spreadsheet icon. Click the first cell in the row or column that you would like to change the text case.
Detailed explanation-2: -– Copy and paste the column in Word. – Highlight the text and click on Change Case icon in Font group (under Home tab). – Copy the text in the output and paste it back in Excel. Note: An alternate method is to select the text in Word and press “Shift+F3” until the case you want appears.
Detailed explanation-3: -Highlight the data you want to transform. Go to the “Insert” tab. Select the “Pivot” table to open a “Create PivotTable” box. Select the table or range and choose the “ChangeCase” option from the dropdown menu.
Detailed explanation-4: -Then, press the Ctrl + Shift + U keys on your keyboard. This shortcut will instantly convert the text in the selected cells to uppercase letters. If you want to convert text to lowercase letters, you can use the Ctrl + Shift + L shortcut.