View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_4_] Bob Phillips[_4_] is offline
external usenet poster
 
Posts: 834
Default Illegal Character Imported

Maybe it is unicode. Have you tried capturing it with ASCW(character)?


---
HTH

Bob Phillips


"Mike H." wrote in message
...
I am importing data from another system into an Excel File. In some cells
I
get a character that in Excel looks like a question mark with a border
around
it. If I copy that character and paste it in the VBA editor, it appears
as
two Double Quotation marks "" with space between them and they are stacked
vertically. Anyway, my question is, how can I test of the existence of
this
character in the cell. If I can detect it is in there I can create a
work-around for my data. Is there some kind of a VBA command that checks
for
the existence of specific ascii characters (I don't know what ascii
character
it is.) Below is a copy of it, pasted in he
"
"

Thanks for any help.