About
Pricing
Community
Teams
Start Free Trial
Log in
mcrmg
asked on
10/17/2018
URL in SQL
Hi,
I am displaying url in the output of a query. Is there a way to show "actual" links when I copy and paste to an excel file? thanks
Microsoft Excel
SQL
4
1
Last Comment
mcrmg
8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Martyn Spencer
10/17/2018
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
mcrmg
10/17/2018
ASKER
yes, this works. thank you
Martyn Spencer
10/17/2018
Excellent. Just to correct my solution, the code block should have read
=HYPERLINK("url")
Select all
Open in new window
I am not sure how I managed to pick up a spurious ( character.
mcrmg
10/17/2018
ASKER
That is okay...thanks again...
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23