Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Posts
    159
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Stripping Formats (XP)

    I have an Excel source document that I have created by pasting from one of my sites on the Internet.
    It contains hyper links and button formats that I would like to strip out, and create simple Excel tables.

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Stripping Formats (XP)

    To kill the button objects select Edit | Goto | Special | Objects | OK, and then hit the delete key. To remove hyperlinks, see <!post=this thread,362286>this thread<!/post>. Post back if those two steps leave other undesirable artifacts.
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Stripping Formats (XP)

    Have you tried using Paste Special from the Edit Menu. Select text from the list. This will also remove most buttons graphics and hyperlinks!
    Regards,
    Rudi

Posting Permissions

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