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

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

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