This method will introduce a User Defined Function to remove all kinds of punctuation marks from cells in Excel easily. Please do as follows:

1. Press the Alt + F11 keys to open the Microsoft Visual Basic for Applications window.

2. Click Insert > Module, and then copy and paste the following code into the new opening Module window.

VBA: Remove Punctuation marks from cells in Excel

Function RemovePunctuation(Txt As String) As String
With CreateObject("VBScript.RegExp")
.Pattern = "[^A-Z0-9 ]"
.IgnoreCase = True
.Global = True
RemovePunctuation = .Replace(Txt, "")
End With
End Function

3. Save the User Defined Function and close the Microsoft Visual Basic for Applications window.

4. Select a blank cell you will output result, enter the formula =RemovePunctuation(A2) (A2 is the cell you will remove all punctuation marks from) into it, and then drag the Fill Handle to the range as you need.

And then you will see all kinds of punctuation marks are removed. See screenshot:

This method will introduce Kutools for Excel’s Remove Characters utility to quickly remove all kinds of punctuation marks from selected range at once. Please do as follows:

1. Select the range you will remove all punctuation marks from, and click Kutools > Text > Remove Characters. See screenshot:

2. In the opening Remove Characters dialog box, please only check the Custom option, and type the punctuation marks ~!@#$%^&*()_-+={}[]:;""''<>,./?`\| into below box, and click the Ok button. See screenshot:

And then you will see all kinds of punctuation marks are removed from selected cells. See above screenshot.

How to remove letters from strings/numbers/cells in Excel?

How to remove numbers from text strings in Excel?