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

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

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

Please Login or Register  to view this content.

Originally Posted by 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.

Please Login or Register  to view this content.

I tried that and get the following:

Cannot open the specified file

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:

Please Login or Register  to view this content.

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.

Here is what I see when I attempt the above:

Originally Posted by Tunney

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.

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