I am looking for a formula to automatically create custom hyperlinks into an excel spreadsheet, based on contents of another cell
I have a list of books where I can get the image from an url database. It's the same URL for all books, just the ISBN number i different.
The numbers are also the ISBN number, so I want excel to create a hyperlink based on the contents of cell A (the numbers in bold).
CELL A (ISBN):
How can I make excel change the ISBN number in the URL for all rows?