If you press the space bar in the Replace With text field, Excel will replace all instances of that punctuation with a space, instead of just deleting the punctuation.

Learn how to delete a text box without removing text in Word or Excel using Format Shape pane, setting the text box to No Outline, and more.

This tutorial explains how to delete a text vertically in a Word document or Excel spreadsheet without deleting all the text horizontally.