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

265 thoughts on “Convert pasted URL to standard Hyperlink text automatically

  1. DC office movers

    Good post and right to the point. I don’t know if this is in fact the best place to ask but do you guys have any thoughts on where to hire some professional writers? Thanks in advance 🙂

  2. african music

    I’m not sure where you are getting your information, but good topic. I needs to spend some time learning more or understanding more. Thanks for magnificent info I was looking for this information for my mission.

  3. evans syndrome

    Hey, I think your site might be having browser compatibility issues. When I look at your blog in Safari, it looks fine but when opening in Internet Explorer, it has some overlapping. I just wanted to give you a quick heads up! Other then that, awesome blog!

  4. jordan shoes

    I must express some appreciation to the writer just for bailing me out of this challenge. Just after scouting throughout the the net and finding thoughts that were not pleasant, I believed my entire life was done. Living without the presence of approaches to the issues you’ve fixed through your good posting is a critical case, and those that could have badly affected my entire career if I had not encountered the website. That training and kindness in playing with a lot of stuff was invaluable. I’m not sure what I would’ve done if I hadn’t encountered such a subject like this. I’m able to now relish my future. Thank you so much for this specialized and amazing guide. I won’t hesitate to propose your site to any individual who would like assistance on this situation.

  5. Australian Office Furniture Buy

    I’ve been exploring for a little for any high-quality articles or blog posts on this kind of space . Exploring in Yahoo I ultimately stumbled upon this website. Studying this info So i’m glad to exhibit that I’ve an incredibly good uncanny feeling I found out exactly what I needed. I such a lot indisputably will make sure to do not forget this site and provides it a look on a relentless basis.

  6. Moving help

    Hello There. I found your blog using msn. This is a really well written article. I will make sure to bookmark it and return to read more of your useful info. Thanks for the post. I will certainly comeback.

  7. verthilertva

    Thank you for sharing superb informations. Your web-site is very cool. I am impressed by the details that you¦ve on this site. It reveals how nicely you understand this subject. Bookmarked this web page, will come back for more articles. You, my friend, ROCK! I found just the information I already searched all over the place and just couldn’t come across. What an ideal website.

  8. Recruitment Services

    Hey There. I found your blog using msn. This is a very well written article. I will be sure to bookmark it and come back to read more of your useful info. Thanks for the post. I will certainly return.

  9. Software

    I truly wanted to make a quick word so as to thank you for the splendid recommendations you are showing on this site. My extensive internet search has at the end of the day been honored with awesome strategies to talk about with my company. I ‘d tell you that many of us website visitors actually are truly fortunate to exist in a magnificent place with many brilliant people with good things. I feel really lucky to have encountered your weblog and look forward to plenty of more amazing times reading here. Thanks a lot again for a lot of things.

  10. Bulk CBD Oil

    Thanks for another fantastic article. The place else may just anyone get that type of information in such a perfect method of writing? I have a presentation subsequent week, and I am at the look for such info.

  11. amazon discount

    I’m really impressed with your writing skills and also with the layout on your blog. Is this a paid theme or did you modify it yourself? Either way keep up the excellent quality writing, it’s rare to see a nice blog like this one nowadays..

  12. Toronto

    Needed to put you the bit of observation to be able to say thank you the moment again over the breathtaking tips you’ve contributed in this case. This is really extremely open-handed of people like you to grant unreservedly all that many people might have marketed as an e-book to help with making some money for themselves, notably given that you could have tried it in the event you desired. The basics as well served to be a fantastic way to be sure that other people have a similar fervor like mine to know the truth significantly more when it comes to this problem. I think there are numerous more enjoyable sessions up front for individuals who check out your website.

Leave a Reply

Your email address will not be published. Required fields are marked *