Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Dec 2000
    Location
    Palmyra, Virginia, USA
    Posts
    157
    Thanks
    0
    Thanked 0 Times in 0 Posts

    getting rid of javascript (Excel 2000)

    I have been copying tabular data from an .asp based website into an Excel 2000 spreadsheet. When I paste into the sheet I get, along with the data, a symbol that apparently indicates that javascript is embedded. I can open an editor and delete the actual javascript code but I can't get the symbol to go away. (Well, I can save the sheet in a format that doesn't support JS but that's a nuisance.) If I use paste special, I lose all the formatting. Anyone know an easy way to get rid of the unwanted code and symbol?

  2. #2
    5 Star Lounger
    Join Date
    Oct 2002
    Location
    Wellington, Wellington, New Zealand
    Posts
    621
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: getting rid of javascript (Excel 2000)

    I believe that you can do a double-pass on paste special
    Once with values and once with formatting

    Edited to add another thought here <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    Or, you could just paste first, then paste values over the top

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •