hyperlinks in Excel 2010

April 24, 2012 at 00:41:51
Specs: Windows 7
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 ?

See More: hyperlinks in Excel 2010

Report •

April 24, 2012 at 04:52:55
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.

Report •

April 24, 2012 at 05:23:52
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.

Report •

Related Solutions

Ask Question