Creating multiple hyperlinks from a column where the text in the .

G

Guest

I wish to create multiple hyperlinks where the hyperlink text is determined
by the cell value.
Example the cell A3 with value 12345 would link to
website.com/generic/12345/12345.html
A5 with value 23456 would link to website.com/generic/23456/23456.html
and so on for 1500 cells.
I'd prefer to avoid using macros as most people disable them.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating multiple hyperlinks from a column where the text in the . 5
HYPERLINK() referring value from a cell does not change when cell 1
How do I convert a column of cells with text emails to hyperlink to email ... 2
Pulling Multiple Text Strings in a One Cell 4
Copy hyperlinks 6
Create a formula by joining text and the value from a formula 3
Creating an Excel sheet with Addresses using a Macro 2
indirect referencing cells with hyperlinks brings text not link- any solution? 4

Top