How can I insert a hyperlink in the middle of text in an Excel cell?
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.
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:
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.Please Login or Register to view this content.
Here is what I see when I attempt the above:
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks