Start Excel. Click the "File" tab. Click "Open." Browse to the spreadsheet with highlighted text and double-click the XLS or XLSX file name. Scroll to the section with the highlight.

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 will eliminate duplicate entries, leaving unique values. This method might remove duplicates in your data that you'd like to keep, so if this happens, consider manually deleting the data ...

The TRIM functions in this formula remove any consecutive duplicate spaces from the phrase, just in case the phrase happens to contain extra spaces between the words or ­additional spaces after the ...