Deleting HTML form objects?
See if this "quick fix" works
Select a single cell...then
Press the [F5] key........that's the shortcut for <edit<go to
Click the [Special] button
Select: Objects
Click the [OK] button
(all of the objects should now be selected)
Next...just press the [Delete] key
Does that help?
***********
Regards,
Ron
XL2002, WinXP
"GeorgeM" wrote:
I frequently need to copy and paste a page from one of our website's
admin screens into a spreadsheet. The HTML page includes HTML forms,
like check boxes and drop-down lists.
I can't figure out how to get rid of these HTML form elements.
Deleting the column they appear to be in just moves them into the
adjacent column on the right. Deleting the single cell the object
appears to be in has unpredictable results - sometimes it works,
sometimes it doesn't.
I'm pasting as HTML, because the table in HTML drops so nicely into
cells. If I paste as Text, each row is a useless unformatted string.
Any solutions?
Thanks
George
|