I am creating a web page from an Excel spreadsheet.
I have a hyperlink attached to an image.
How can I add _target="blank" to the URL ?
I'm not 100% sure what you are trying to do, but I'll toss these 2 suggestions... 1 - If you click and hold on a cell that contains a hyperlink you can edit it.
2 - You can use the concatenation operator & to combine strings.
=A1 & "_target="blank""
You'll have to play with the quotes. I don't have Excel available to me right now so I can give you the exact formula.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
Thanks for the reply, but it not the answer I am seeking.
By right clicking on a cell in Excel, you can select 'hyperlink'.
You can then enter a URL in the 'address' box.
Effectively this URL is applied to whatever text is in the cell.
I then wish to save the file as a web page in html.What I would like to put in the 'address' box is some code so that when clicked on in the web page, will open the hyperlink in a new window.