Convert pasted URL to standard Hyperlink text automatically

I am looking to understand the following.

A friend of mine (can’t reach him for a while) created a formula that does this:

When you COPY (CTRL+C) a URL from your browser and then go to a cell in an Excel sheet that displays the word LINK (with the formula I copied below in it) and replace the formula (Select all and delete, then CTRL+V to insert the complete URL) it replaces the original LINK word with the same LINK word but as a hyperlink to the actual pasted URL.

=IF($B447>=1;HYPERLINK(VLOOKUP($A447;’DATA’!$A$1:$AA$619;15;FALSE);”LINK”);””)

I know the basics of Excel, IE; the IF is for determining wether a certain column has any text/value in it and although the formula runs through the column it doesn’t display the word LINK on any rows that have no text in Bxxx (which is what I want). I just can’t seem to recreate this function in a new sheet.

I want the cell (in column N) to say SharePoint as soon as text is entered in column A. Then when a user does CTRL+V in that row’s column N with a URL the cell automatically replaces the word SharePoint with a hyperlink to the actual location on SharePoint and automatically changing the link/address to the word SharePoint instead of displaying the full link.

I think I am having a hard time understading how one can remove a formula and then by copying something else (a URL) the actual, removed, formula does its magic.

Any help is appreciated!

By: Rogier van Dam

2,094 thoughts on “Convert pasted URL to standard Hyperlink text automatically

  1. moedah

    You’re so cool! I do not suppose I’ve read a single thing like this before. So nice to find another person with some original thoughts on this issue. Really.. thanks for starting this up. This site is something that is required on the web, someone with a little originality!

  2. Reductil bestellen

    Thanks for any other informative blog. The place else may I am getting that kind of info written in such an ideal means? I have a undertaking that I’m just now operating on, and I have been at the look out for such information.

  3. udfauzi

    I have to thank you for the efforts you have put in penning this website. I really hope to view the same high-grade blog posts by you in the future as well. In truth, your creative writing abilities has encouraged me to get my very own blog now 😉

  4. 谷歌优化

    Great weblog right here! Also your website
    so much up fast! What web host are you the usage of?

    Can I am getting your associate hyperlink to your
    host? I want my site loaded up as quickly as yours lol

  5. poboleda.org

    Hello there, I think your website might be having web browser compatibility problems. Whenever I take a look at your site in Safari, it looks fine however, if opening in I.E., it has some overlapping issues. I simply wanted to give you a quick heads up! Aside from that, wonderful website!

  6. tokoonline88

    I blog often and I genuinely thank you for your information. Your article has really peaked my interest. I am going to bookmark your blog and keep checking for new information about once per week. I subscribed to your RSS feed as well.

  7. vivoslot.com

    Greetings! Very helpful advice in this particular post! It’s the little changes that make the most significant changes. Thanks a lot for sharing!

  8. vivoslot

    Everything is very open with a clear description of the issues. It was really informative. Your site is very helpful. Many thanks for sharing!

  9. vivo slot online

    Next time I read a blog, I hope that it does not fail me as much as this one. After all, Yes, it was my choice to read, however I really believed you would probably have something interesting to say. All I hear is a bunch of whining about something that you can fix if you weren’t too busy seeking attention.

  10. dingdong 12d live

    You’ve made some really good points there. I checked on the internet for more info about the issue and found most individuals will go along with your views on this site.

  11. dominoqq

    After looking over a handful of the blog articles on your blog, I truly appreciate your technique of writing a blog. I book-marked it to my bookmark webpage list and will be checking back in the near future. Please visit my web site as well and let me know how you feel.

  12. agen judi online

    I blog quite often and I seriously appreciate your content. Your article has truly peaked my interest. I am going to book mark your website and keep checking for new information about once a week. I subscribed to your RSS feed too.

Comments are closed.