VBA to include only a-z in end string
Posted on 2010-11-08
How do I remove all characters not in the range a-z or A-Z.
Essentially, I am looking for code to replace the line in bold below.
Dim sourcestring , destinationstring as string
sourcestring = "abc./ xyzABC"
**destinationstring = replace(sourcest......????
msgbox destinationstring shows "abcxyzABC"