Skip to content
Cha Ching Queen
  • Money MattersExpand
    • Make More Money
    • Spend Less
    • Budget Wisely
    • Financial Planning
    • Reviews & Recommendations
  • Eat WellExpand
    • Bread & Desserts
    • Diets and Eating Habits
    • Healthy Recipes
    • Kitchen Hacks
  • Clean Quickly
  • Live LifeExpand
    • Health & Beauty
    • Family And Relationships
    • Holidays & Gifts
    • At Home
  • Travel Tips
  • About
Cha Ching Queen
ByRachel Reading Time: 4 minutes
Home » Money Matters » Make Money » How to Change Hyperlinks to Text Showing the URL Address in Excel Spreadsheet

How to Change Hyperlinks to Text Showing the URL Address in Excel Spreadsheet

Share on Facebook Share on Pinterest Share on Twitter Share on Email Share on SMS
This post may contain affiliate links. Read the disclosure.

One of the good things about blogging is I’m always learning new things.  When I run into a problem I research ways to solve the problem.

Often, if I have an idea of something I’d like to try, I look around and figure out how to do it.  Even though my husband is a web guy and probably knows most of the answers, I do not like to bother him.

Unfortunately and fortunately, he is busy doing his own work for clients at MBSquared.  Today’s problem was figuring out how to change hyperlinks to text showing the URL address in Excel.   I wanted to convert a column with hyperlinks to only display the links.  I was searching for a way to pull out hyperlinked text from code and have only the URLs displayed.  Does that make sense?

How to Change Hyperlinks to Text Showing the URL Address in Excel - extracting URLs
Excel – Extract Link From Cell

How to Change Hyperlinks to Text Showing the URL Address in Excel

Here’s what I was trying to do.  I use a Tailwind  to schedule my pins.  I love it, by the way.  Anyway, I wanted to pull out the most popular pins and create a spreadsheet with links (URLs displayed) to those pins.

My spreadsheet looked like this, but in order to repin those Pinterest pins in Tailwind, I need the actual URLs.  Yes, I could go one-by-one and extract the URL from each hyperlink (right-click – edit hyperlink – copy URL), but that would be very time-consuming.  I wanted Excel to convert the hyperlink to url.

is there a way to pull out hyperlinked text from code excel

extract the URL from each hyperlink excel time consuming tedious

Luckily, I found a way to convert my column with hyperlinks to display the links in URL form.  Actually, even better, this will extract a URL from a hyperlink and display it in the column beside it.  This little macro code will do all of the tedious work for you and convert every single hyperlink to URL text at the same time!  It lets excel show hyperlink url easily.

Tips for Spreadsheets and Excel – Extract Link From Cell

Directions on How to Change Hyperlinks to Text Showing the URL

First, once your column is selected, in your Excel workbook, go to Tools – Macro – Visual Basic Editor.

Extract a URL from a Hyperlink and Display only the URL Address step 1

Next, once you are in the Visual Basic Editor, go to Insert – Module.

Extract a URL from a Hyperlink and Display only the URL Address step 2 insert module

Then, copy this text into the editor:

Sub ExtractHL()
Dim HL As Hyperlink
For Each HL In ActiveSheet.Hyperlinks
HL.Range.Offset(0, 1).Value = HL.Address
Next
End Sub

extract a url from hyperlink in excel instructions how to module visual basic editor

Finally, run the program by pressing F5 on your keyboard.  Now, you have a separate column that converted your hyperlinks into URL addresses.

separate column how to Change Hyperlinks to Text Showing the URL text address

Yay! You successfully Changed Hyperlinks to Text Showing the URL Address in Excel!   

Next: Here are some helpful tips for business owners and those looking to make some extra cash.

13 Ways To Supplement Your Income From Home

The Ultimate Guide To Develop Online Presence

Three Ways To Increase Your Blog Traffic

Rachel
Website | + posts

Rachel is an Austin blogger, educator, mom, wife, young breast cancer survivor writing about health, saving money, and living a happy life in Austin, Texas.

Rachel has written for HuffPost and Hometalk and has been featured on KXAN, Studio 512, Fox 7 Austin, and CBS Austin.

  • Rachel
    https://chachingqueen.com/author/rachel/
    Personalized Decorated Boxes for Valentine's Day, Mother's Day, Father's Day, More
  • Rachel
    https://chachingqueen.com/author/rachel/
    The Ten Minute Seder: Super Quick Seder
  • Rachel
    https://chachingqueen.com/author/rachel/
    The Best 2023 Free Online Rosh Hashanah Services & Yom Kippur Services
  • Rachel
    https://chachingqueen.com/author/rachel/
    Purim for Kids 2023 - Free Activities with Crafts, Megillah, and More
Share on Facebook Share on Pinterest Share on Twitter Share on Email Share on SMS

Trending Now

How Often Should You Clean Your House: Woman Cleaning Oven

How Often Should You Clean Your House? Room By Room Tips

Woman Doing Laundry Using Earth Breeze Laundry Sheets

Earth Breeze Review: Dehydrated Laundry Sheets

amazon prime box

My Secrets: How To Get Amazon Coupons, Discount Codes, Free Stuff, and Deals

18 Household products you can easily make at home

18+ DIY Household Products You Can Make at Home

Amazon Gift Card

How To Save On Amazon Prime Membership + Prime Benefits

What To Teach Kids About Money

What To Teach Kids About Money: An Expert Weighs In

Share on Facebook Share on Pinterest Share on Twitter Share on Email Share on SMS
This post may contain affiliate links. Read the disclosure.
As Seen On
bloomberg logo
business insider logo
msn logo
usa today logo
family handy man logo
yahoo finance logo
Share on Facebook Share on Pinterest Share on Twitter Share on Email Share on SMS
  • Home
  • About
  • Contact
  • Disclosure
  • Privacy Policy
  • Web Stories
Email Facebook Twitter Instagram Pinterest

© 2023 CHA CHING QUEEN

ChaChingQueen does not provide individual or customized medical, legal, or financial advice. Since each individual's situation is unique, a qualified professional should be consulted about your specific situation before making financial and/or medical decisions.

Cha Ching Queen is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to amazon.com.

  • Money Matters
    • Make More Money
    • Spend Less
    • Budget Wisely
    • Financial Planning
    • Reviews & Recommendations
  • Eat Well
    • Bread & Desserts
    • Diets and Eating Habits
    • Healthy Recipes
    • Kitchen Hacks
  • Clean Quickly
  • Live Life
    • Health & Beauty
    • Family And Relationships
    • Holidays & Gifts
    • At Home
  • Travel Tips
  • About
Facebook Twitter Instagram
Search