RemoveOMatic will do it:
Function Removeomatic(ByVal pstr As String, ByVal pchar As String) As String
'*******************************************
'Name: Removeomatic (Function)
'Purpose: Removed specified characters from a string.
'Inputs: from debug window: ? Removeomatic("123-45-6789", "-")
'Output: 123456789
'*******************************************
Dim strHold As String
strHold = RTrim(pstr)
Do While InStr(strHold, pchar) > 0
strHold = Left(strHold, InStr(strHold, pchar) - 1) & Mid(strHold, InStr(strHold, pchar) + 1)
Loop
Removeomatic = strHold
End Function