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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Spreadsheet object in VBE appears with the ThisWorkbook icon 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Cell off grid error after generating Excel spreadsheet as XML 2
PageSetup - Speeding up - Code snippet Requested 5
My ref: RN0001 Find the first & last occurrence of a strings 5
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
XML Spreadsheet Warning in Table - Cell Of Grid 2
CSV file containing Thai characters does not load into right colum 2

Back
Top