VBA code to strip # sign

[HWL]

I have code I made to strip all letters from a cell. I made a user function called "letterout" -- see below, however I also want to strip the pound sign out of the string.

Function LetterOut(rng As Range)
Dim i As Integer
For i = 1 To Len(rng)
Select Case Asc(Mid(rng.Value, i, 1))
Case 0 To 64, 123 To 197
LetterOut = LetterOut & Mid(rng.Value, i, 1)
End Select
Next i
End Function
​

I imagine it is another Case number but have no idea which. Help?

 

[HWL]

I'm sorry... I did not notice you called the function by a singular name... I thought I read it as being plural (because you were removing more than one character). I'm glad you spotted that. Again, sorry for doing that to you.

no problem, plural makes more sense. Thanks so much for your help. This will be a very useful tool.