How to Delete Punctuation & All Caps in Excel. When you prepare employee salary reports, revenue charts and other business financials, you may find yourself inputting more than just numerical ...

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 ...