How to Delete Punctuation & All Caps in Excel. When you prepare employee salary reports, ... Type the first instance of all capital letters to change into the Find What text field.

Open the Excel document that contains the words that you want to change to all caps. Right-click on the header of the column to the right of the column of text that you want to convert to all caps.

If there isn’t any specific font to display the data in your Excel spreadsheet, you may change lowercase to uppercase using an All Caps font, such as Algerian, Copperplate Gothic, and Engravers MT.

Excel doesn't offer a one-click solution if you need text in sentence case (where only the first letter of the sentence is capitalized). But don’t worry! You can create a custom formula using the LEFT ...