MS Excel Question

[Starbuck1975]

I already know that you can create a hyperlink associated to a cell, such that when you click on the cell, it takes you to the hyperlink location.

I have a situation where I need to document numerous hyperlinks in one cell, where each of the individual hyperlinks remain active.

My team currently accomplishes this by doing the following. Let's say that a particular cell needs to contain the following hyperlinks:

http://anandtech.com
http://hotmail.com
http://cnn.com

Our team simply reverses the forward slashes to back slashes, such that MS Excel doesn't recognize them as hyperlinks...as follows:

http:\\anandtech.com
http:\\hotmail.com
http:\\cnn.com

However, this isnt particularly effective, as the intent is for each hyperlink to be active.

I have done some digging around online, and can only find one workaround...placing an MS Word Object within Excel, and then typing in as many hyperlinks as I want. However, the MS Word Object does not remain associated to the cell...it sort of just sits on top of it.

So my question is...how do you create numerous active hyperlinks that remained associated to the cell in which they reside?

 

[tw1164]

I don't think you can.

 

[Thyme]

Originally posted by: tw1164
I don't think you can.

That'd be my guess, too. Excel is pretty awful for text. You might be able to use VBA if there's a hook for clicking inside a cell that will give you the position, but that seems far fetched.

 

[Starbuck1975]

There is a VB work around, but the powers that be dont want me fiddling with their spreadsheet.