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!

Try this,
Edit Go To Special, check 'Objects' OK
If this highlights them all you can delete them.
Regards,
Alan.
"shamrock1269" wrote in message
...
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!

Tried it, didn't work, but thanks very much for the advice.

Any more advice would be much appreciated

"Alan" wrote:

Try this,
Edit Go To Special, check 'Objects' OK
If this highlights them all you can delete them.
Regards,
Alan.
"shamrock1269" wrote in message
...
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!

Try showing the Control Toolbox toolbar
In xl2003 menus:
View|Toolbars

Then click on the Design mode icon

Then use:
Edit|Goto|Special|objects
and hit the delete key on the keyboard

Then leave design mode (just click on that icon once more)

shamrock1269 wrote:

Tried it, didn't work, but thanks very much for the advice.

Any more advice would be much appreciated

"Alan" wrote:

Try this,
Edit Go To Special, check 'Objects' OK
If this highlights them all you can delete them.
Regards,
Alan.
"shamrock1269" wrote in message
...
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!



--

Dave Peterson

Can you translate to Excel 2007?

"Dave Peterson" wrote:

Try showing the Control Toolbox toolbar
In xl2003 menus:
View|Toolbars

Then click on the Design mode icon

Then use:
Edit|Goto|Special|objects
and hit the delete key on the keyboard

Then leave design mode (just click on that icon once more)

shamrock1269 wrote:

Tried it, didn't work, but thanks very much for the advice.

Any more advice would be much appreciated

"Alan" wrote:

Try this,
Edit Go To Special, check 'Objects' OK
If this highlights them all you can delete them.
Regards,
Alan.
"shamrock1269" wrote in message
...
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!



--

Dave Peterson

You have to show the 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.


shamrock1269 wrote:

Can you translate to Excel 2007?

"Dave Peterson" wrote:

Try showing the Control Toolbox toolbar
In xl2003 menus:
View|Toolbars

Then click on the Design mode icon

Then use:
Edit|Goto|Special|objects
and hit the delete key on the keyboard

Then leave design mode (just click on that icon once more)

shamrock1269 wrote:

Tried it, didn't work, but thanks very much for the advice.

Any more advice would be much appreciated

"Alan" wrote:

Try this,
Edit Go To Special, check 'Objects' OK
If this highlights them all you can delete them.
Regards,
Alan.
"shamrock1269" wrote in message
...
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!



--

Dave Peterson


--

Dave Peterson

Thanks for the advice! I did that, didn't work. I've ended up having to
delete them all by hand.

"Dave Peterson" wrote:

You have to show the 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.


shamrock1269 wrote:

Can you translate to Excel 2007?

"Dave Peterson" wrote:

Try showing the Control Toolbox toolbar
In xl2003 menus:
View|Toolbars

Then click on the Design mode icon

Then use:
Edit|Goto|Special|objects
and hit the delete key on the keyboard

Then leave design mode (just click on that icon once more)

shamrock1269 wrote:

Tried it, didn't work, but thanks very much for the advice.

Any more advice would be much appreciated

"Alan" wrote:

Try this,
Edit Go To Special, check 'Objects' OK
If this highlights them all you can delete them.
Regards,
Alan.
"shamrock1269" wrote in message
...
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!



--

Dave Peterson


--

Dave Peterson

That's too bad. It worked for me.

shamrock1269 wrote:

Thanks for the advice! I did that, didn't work. I've ended up having to
delete them all by hand.

"Dave Peterson" wrote:

You have to show the 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.


shamrock1269 wrote:

Can you translate to Excel 2007?

"Dave Peterson" wrote:

Try showing the Control Toolbox toolbar
In xl2003 menus:
View|Toolbars

Then click on the Design mode icon

Then use:
Edit|Goto|Special|objects
and hit the delete key on the keyboard

Then leave design mode (just click on that icon once more)

shamrock1269 wrote:

Tried it, didn't work, but thanks very much for the advice.

Any more advice would be much appreciated

"Alan" wrote:

Try this,
Edit Go To Special, check 'Objects' OK
If this highlights them all you can delete them.
Regards,
Alan.
"shamrock1269" wrote in message
...
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!



--

Dave Peterson


--

Dave Peterson


--

Dave Peterson