Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to delete a "return" character (a "box") in cell of imported d | Excel Programming | |||
Help removing "space" character from imported data | Excel Discussion (Misc queries) | |||
Remove character from imported data | Excel Discussion (Misc queries) | |||
illegal division by 100 | Excel Discussion (Misc queries) | |||
Illegal Operation | Excel Programming |