To change existing text to all caps, create a copy using UPPER and paste it back to the original cells.
-
In a blank cell, row, or table, enter =UPPER(A1) in the Formula bar where A1 is the cell(s) you want to make uppercase.
-
To copy the results and paste over the original text, press ⌘+C, select the original cell(s), right-click, select Paste Special (^⌘ V), choose Values and then OK.
For more info, see Change capitalization.
To change existing text to all caps, create a copy using UPPER and paste it back to the original cells.
-
In a blank cell, row, or table, enter =UPPER(A1) in the Formula bar where A1 is the cell(s) you want to make uppercase.
-
To copy the results and paste over the original text, press Ctrl+C, select the original cell(s), right-click and select Values (Ctrl+Shift+V) under Paste Options.
For more info, see Change capitalization.