I need to insert a hyperlink in the middle of a cell that contains text in Excel 2010.

[Tunney]

How can I insert a hyperlink in the middle of text in an Excel cell?

[snax]

You would need to do something like the formula below. You also need to make sure that the cell isn't formatted as text.

="Your first part of text here "&hyperlink("your link here","what you want the link to display as here")&" the second part of your text here."

[Tunney]

You would need to do something like the formula below. You also need to make sure that the cell isn't formatted as text.

="Your first part of text here "&hyperlink("your link here","what you want the link to display as here")&" the second part of your text here."

I tried that and get the following:

Cannot open the specified file

[snax]

I tried that and get the following:

Cannot open the specified file

Are you setting up the hyperlink correctly? If you hover over the link it should show you the address that the link is going to. If the link is not set up properly then you will continue to receive the error that you got. If you post the link that you want, I can change the formula to have the link in it for you.

[Tunney]

See my previous reply with file attached at 11:28.

[Betty00]

Suppose you want to insert B3, in B3, I set the text to be "Home Page". I need to insert anchor link like below code:

            sheet.Range["B3"].Text = "Home Page";
            HyperLink link1 = sheet.HyperLinks.Add(sheet.Range["B3"]);
            link1.Type = HyperLinkType.Url;
            link1.TextToDisplay = sheet.Range["B3"].Text;
            link1.Address = @"http://www.excelforum.com";

It works fine or me by a .NET Excel library(http://www.codeproject.com/Catalogs/3785/Spire-XLS.aspx). You can give it a try.

[Tunney]

Here is what I see when I attempt the above: