Excel only permits deletion of one character or word at a time. It may be helpful for you to write down all the different punctuations and all capitals you wish to delete so you can cross them off ...

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