Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Feb 2005
    Posts
    207
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Hyperlink (Excel 2003)

    I have Hyperlinks in cells A1:A200.

    What is the fastest way to move all the hyperlinks and just have text remaining?

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Hyperlink (Excel 2003)

    In B1 enter:
    <pre>=A1</pre>


    Copy/autofil B1 to B2:B200

    Select B1:B200, copy, paste-special values to B1
    Copy B1:B200 to A1
    Erase B1:B200

    You could also do a macro ir you do this routinely
    Steve

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Hyperlink (Excel 2003)

    Here is a macro to do it.

    Steve

    <pre>Option Explicit
    Sub RemoveHL()
    Dim rCell As Range
    For Each rCell In Range("A1:A200")
    If rCell.Hyperlinks.Count > 0 Then
    rCell.Hyperlinks(1).Delete
    End If
    Next
    End Sub
    </pre>


Posting Permissions

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