Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

How do you unlink an email or web address

Latest post Sat, Jan 30 2010 7:02 PM by Jim Cone. 3 replies.
  • Sat, Jan 30 2010 2:43 PM

    • grmgroup
    • Top 200 Contributor
    • Joined on Tue, Jan 22 2008
    • Posts 3
    • Points 95

    How do you unlink an email or web address

    I'm making several mail lists for in-house promo in excel. Once completed, I will use in data merge. My problem is emails are entering as links. I don't want this. Often times, I send to several persons from same company so I copy the first email (janedoe@thisverylongcompanyname.com) and paste for each new person, changing only the contact. However, all of the pasted emails will cause go to the first company recipient I created because she is the link. I don't what that. I want straight text without links. Same with web addresses. I did a google search and almost all tell me how to make a link. I want to unlink all my emails and website addresses.

    Thx.

    • Post Points: 37
  • Sat, Jan 30 2010 3:19 PM In reply to

    • Jim Cone
    • Top 10 Contributor
    • Joined on Tue, Jan 15 2008
    • Portland, Oregon - USA
    • Posts 117
    • Points 1,591

    Re: How do you unlink an email or web address

    Copy the cells and paste values back into them.
    Clear all formats from the cells. (edit menu)

    • Post Points: 5
  • Sat, Jan 30 2010 3:55 PM In reply to

    • CurtisB
    • Top 50 Contributor
    • Joined on Thu, Jun 25 2009
    • Posts 14
    • Points 197

    Re: How do you unlink an email or web address

    Something else you can check is the Autocorrect feature.  Uncheck automatic hyperlinking.

     

    HTH

    Curtis

    • Post Points: 5
  • Sat, Jan 30 2010 7:02 PM In reply to

    • Jim Cone
    • Top 10 Contributor
    • Joined on Tue, Jan 15 2008
    • Portland, Oregon - USA
    • Posts 117
    • Points 1,591

    Re: How do you unlink an email or web address

    The solution I posted earlier only works with Hyperlink formulas.
    The following piece of VBA code works on Hyperlink objects and Email address links. Select the the cells and run the code...

    Sub RunToRemoveHyperlinksAndEmailLinks()
      Selection.Hyperlinks.Delete
    End Sub

    • Post Points: 5
Page 1 of 1 (4 items) | RSS
Copyright Excel User Group and the relevant contributors, 2009. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.