+ Reply to Thread
Results 1 to 10 of 10

Remove Hyperlinks function in Hyperlinks

  1. #1
    Registered User
    Join Date
    07-07-2014
    Location
    the Netherlands
    MS-Off Ver
    2016
    Posts
    56

    Remove Hyperlinks function in Hyperlinks

    If e.g. a cell has the function =+HYPERLINK("http://www.excelforum.com";"Excel Forum"), I want to copy this cell to an other cell which has only the name "Excel Forum", which act as usaully, that means click on the name will move you to that hyperlink.

    I did a lot of reading for a solution by means of Google and found only one, the same as I found allready myself:
    - Copy the original cell and paste it in a Word document. There you find the hyperlink form as I want. Then copy this hyperlink back to Excell and ready.

    But that must be possible without using Word as immediate. But How?

    Kind reagrds

    Jan Lichtenbelt

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,239

    Re: Remove Hyperlinks function in Hyperlinks

    Im confused

    You want to copy a particular cell (that happens to contain a hyperlink), to another cell that already contains something, and you want that "something" to become part of the stuff copied from the 1st cell?

    If thats the case, That's not possible with regular formulas - as soon as you paste the date to the new cell, it will completely over-write the contents of the new cell

    If thats not what you meant/wanted, perhaps explain again (maybe step-by-step?)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    07-07-2014
    Location
    the Netherlands
    MS-Off Ver
    2016
    Posts
    56

    Re: Remove Hyperlinks function in Hyperlinks

    I want cell A1, with the formula =+Hyperlink(), to be converted into the form like C1 (as said a form equal as met in e.g. Word documents).
    Remark: Cell C1 is a real hyperlink, while cell A1 is not recognised is hyperlink using VBA.

    The question still is how can I convert A1 into C1 in the worksheet or VBA?

    Kind regards

    Jan Lichtenbelt

    Testhyperlinks.xlsm

  4. #4
    Registered User
    Join Date
    07-07-2014
    Location
    the Netherlands
    MS-Off Ver
    2016
    Posts
    56

    Re: Remove Hyperlinks function in Hyperlinks

    Can someone help me with this problem?

    There SHOULD BE a solution!

    Kind regards

    Jan Lichtenbelt

  5. #5
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: Remove Hyperlinks function in Hyperlinks

    How about ?

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Click just below left if it helps, Boo?ath?

  6. #6
    Registered User
    Join Date
    07-07-2014
    Location
    the Netherlands
    MS-Off Ver
    2016
    Posts
    56

    Re: Remove Hyperlinks function in Hyperlinks

    Dear boopathiraja

    The formula Text() give just only the text and not the hyperlink as should be.

    Thanks for help.

    Kind regards

    Jan Lichtenbelt

  7. #7
    Registered User
    Join Date
    07-30-2011
    Location
    Michigan
    MS-Off Ver
    Excel 2007
    Posts
    83

    Re: Remove Hyperlinks function in Hyperlinks

    I believe the question is this: how to convert a formula-based hyperlink into an "inserted" hyperlink? That's going to be a VBA solution.

  8. #8
    Registered User
    Join Date
    07-07-2014
    Location
    the Netherlands
    MS-Off Ver
    2016
    Posts
    56

    Re: Remove Hyperlinks function in Hyperlinks

    VBA or not-VBA, what will be a solution?

    Kind regards

    Jan Lichtenbelt

  9. #9
    Registered User
    Join Date
    07-07-2014
    Location
    the Netherlands
    MS-Off Ver
    2016
    Posts
    56

    Re: Remove Hyperlinks function in Hyperlinks

    Dear All,

    The solution to copy an cell to an new hyperlink cell, has been found
    http://www.vbforums.com/showthread.p...ormat-RESOLVED

    Dim h as Hyperlink

    For each h in SourceRange

    MyWorkSheet.Hyperlinks.Add TargetRange, h.Address

    Next h



    With kind regards

    Jan Lichtenbelt

  10. #10
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: Remove Hyperlinks function in Hyperlinks

    Hi thanks for the feedback and ref...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel Hyperlinks in Powerpoint Error - Hyperlinks stripped
    By memsimpson in forum Excel General
    Replies: 1
    Last Post: 05-27-2014, 01:55 PM
  2. Excel Hyperlinks in Powerpoint Error - Hyperlinks stripped
    By memsimpson in forum Excel General
    Replies: 0
    Last Post: 05-27-2014, 09:25 AM
  3. Find Hyperlinks, Copy Hyperlinks to alternative sheet, print all hyperlinks
    By matrixpom in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-13-2013, 05:13 PM
  4. Replies: 7
    Last Post: 06-14-2012, 09:44 AM
  5. Replies: 0
    Last Post: 05-14-2006, 11:45 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1