Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Strange character pops up in my spreadsheet
I am seeing a strange character appear in my spreadsheet cells. It
looks like a capital A with a squiggle on top. This happens when I export a grid from a web page. (I created the grid in a web page but diverted the output to excel). The grid works fine when it has numbers in it, but any blank cells in the HTML grid show up as capital A's (with squiggles) in Excel. Why is this happening? Thanks, Marvin |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Strange character pops up in my spreadsheet
There is probably something in the data you imported that produces a byte
that Excel sees as the ASCII equivalent of A with a tilde. " wrote: I am seeing a strange character appear in my spreadsheet cells. It looks like a capital A with a squiggle on top. This happens when I export a grid from a web page. (I created the grid in a web page but diverted the output to excel). The grid works fine when it has numbers in it, but any blank cells in the HTML grid show up as capital A's (with squiggles) in Excel. Why is this happening? Thanks, Marvin |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Strange character pops up in my spreadsheet
Which is most likely Alt + 0195
You can probably clear them using EditReplace Gord Dibben MS Excel MVP On Mon, 7 Jul 2008 08:56:03 -0700, JLGWhiz wrote: There is probably something in the data you imported that produces a byte that Excel sees as the ASCII equivalent of A with a tilde. " wrote: I am seeing a strange character appear in my spreadsheet cells. It looks like a capital A with a squiggle on top. This happens when I export a grid from a web page. (I created the grid in a web page but diverted the output to excel). The grid works fine when it has numbers in it, but any blank cells in the HTML grid show up as capital A's (with squiggles) in Excel. Why is this happening? Thanks, Marvin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Strange problem with spreadsheet | Excel Programming | |||
strange character | Excel Discussion (Misc queries) | |||
Strange Character | Excel Programming | |||
Strange problem: spreadsheet locked when macro is stopped | Excel Programming | |||
Identify strange character | Excel Programming |