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