Strange character pops up in my spreadsheet

  • Thread starter Thread starter COHENMARVIN
  • Start date Start date
C

COHENMARVIN

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
 
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.
 
Which is most likely Alt + 0195

You can probably clear them using Edit>Replace


Gord Dibben MS Excel MVP
 
Back
Top