excel hyperlinks

caj1980

Board Regular
Joined
Oct 23, 2013
Messages
107
I have a column of unique text values that are URLs (web addresses). I need to convert all of them to hyperlinks that point to the unique URL but want all of the rows to display the same text. My actual dataset is hundreds of rows.

Data
www.1234.com
www.5678.com
www.9101.com

Desired output (Same Display As with unique Target)
Link
Link
Link

Thanks!
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
This should work:

With your original link / text in A1 etc:

=hyperlink(a1,"Link")

etc...
 

Watch MrExcel Video

Forum statistics

Threads
1,099,803
Messages
5,470,881
Members
406,733
Latest member
darzu

This Week's Hot Topics

Top