excel hyperlinks

[caj1980]

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!

 

[PaddyD]

This should work:

With your original link / text in A1 etc:

=hyperlink(a1,"Link")

etc...

 

[caj1980]

This should work:

With your original link / text in A1 etc:

=hyperlink(a1,"Link")

etc...

Nailed it! Thanks, PaddyD!