Nokia C3: There is a tiny question mark in every box in Microsoft Excel

There is a tiny question mark in every box in Microsoft Excel
I am editing a spreadsheet of unknown origins, it has been suggested that it is copied from html. It is a 4000 line SS. In each cell, at the end of each text line within the cell, there is a tiny box with a question mark in it. I have tried to delete, and they will not go away. I have copied and pasted, pasted special, pasted into Word and back...no luck. In addition, when I attempt to filter, the list shows only 2 selections. There are no blank cells. I am pulling my hair out. Help please!
Reply With Quote
#2
Old 13-01-2012
BillieJ BillieJ is offline
Member

Join Date: Jul 2011
Posts: 367
Re: There is a tiny question mark in every box in Microsoft Excel
Try this out which might help you. Click on Edit > Go To > Special, check 'Objects' > OK. If this highlights them all you can delete them.
Reply With Quote
#3
Old 13-01-2012
Gania Gania is offline
Member

Join Date: Nov 2010
Posts: 480
Re: There is a tiny question mark in every box in Microsoft Excel
Click to view developer's tab on the ribbon.That's under the office button|excel options. It's a checkbox in the top section of the Popular category. Then look in the Developer's group(?) on the ribbon. You'll see a big old Design Mode Icon near the middle.