Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-02-2020, 12:00 AM
pokerguy pokerguy is offline CSV - Hyperlink - creating Windows 10 CSV - Hyperlink - creating Office 2010 32bit
Novice
CSV - Hyperlink - creating
 
Join Date: Mar 2018
Posts: 3
pokerguy is on a distinguished road
Default CSV - Hyperlink - creating

Hello, I need to find a way to create a hyperlink in a cell that already contains a URL. I can go to the Fx box on top showing the URL, click it and hit enter. This will create the link in the cell. BUT, I have thousands and it would take too much time.



Maybe a macro would work. I tried recording one and was not able to. I am able to click the F2 key and then the Enter key and a hyperlink is created. Would live to have a macro for this so I can use it for many rows at a time.

Is there a faster way? Please email me at poker@tampabay.rr.com with you advice.


Many thanks in advance.
Reply With Quote
  #2  
Old 12-02-2020, 01:04 AM
Purfleet Purfleet is offline CSV - Hyperlink - creating Windows 10 CSV - Hyperlink - creating Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

Doesnt =HYPERLINK(K2,K2) work?
Attached Files
File Type: xlsx CSV - Hyperlink - creating_purfleet.xlsx (9.0 KB, 7 views)
Reply With Quote
  #3  
Old 12-02-2020, 01:15 AM
ArviLaanemets ArviLaanemets is offline CSV - Hyperlink - creating Windows 8 CSV - Hyperlink - creating Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

A couple on minutes with Google, and here you go!
How do I convert a column of text URLs into active hyperlinks in Excel? - Stack Overflow

Before searching with google, I tried exactly what is recommended there as first <=HYPERLINK(...)>, and it worked.
Reply With Quote
  #4  
Old 12-02-2020, 11:27 AM
pokerguy pokerguy is offline CSV - Hyperlink - creating Windows 10 CSV - Hyperlink - creating Office 2010 32bit
Novice
CSV - Hyperlink - creating
 
Join Date: Mar 2018
Posts: 3
pokerguy is on a distinguished road
Default

Thanks for the info.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating A Keyboard Shortcut In Place of Using Mouse To Select Hyperlink Object PowerPointerNeedsHelp PowerPoint 3 07-06-2017 01:47 AM
Help creating a hyperlink drop down list between documents SconnieGuy91 Word 3 11-30-2016 05:26 PM
CSV - Hyperlink - creating Creating a hyperlink from Control Content Using CRM Word Templates RFielding@ipmglobal.net Mail Merge 2 06-12-2016 04:06 PM
CSV - Hyperlink - creating Creating internal hyperlink that highlights specific text within a word doc WR748 Word 1 03-16-2015 05:22 AM
Creating A Hyperlink Techknology Outlook 0 11-30-2006 01:16 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:32 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft