Odd symbol when stripping characters using vba

  • Thread starter Thread starter hlock
  • Start date Start date
H

hlock

I'm coming across an odd symbol when I'm trying to strip out the illegal
characters in the subject line of an email. I can't replicate the symbol,
but have a .jpg picture of it. In the email subject line it usually appears
as a blank space. In the vba statement it looks like a vertical line with
horizontal elbow line to the right. If anyone knows what it might be, do you
have any suggestions on how to remove it?
Thanks!
 
What is the character value of that odd symbol? Use the ASC() function to
get a number so we know what you're talking about.
 
It is a tab character that is showing up in the subject line of some emails.
Ascii character 9. Since we use the subject line as the name of the email
file, I was able to replace it with an underscore. Thank you for your help.
 
Back
Top