Excel 2003: Define custom Hyperlink in cell that contains function

**myCellEqualsNull** · 04-06-2010, 08:42 PM

My goal is to create a hyperlink within a specific cell that is based on the contents of another cell. If that's not enough, the cell in which I would like to create this custom hyperlink already contains a function. So, let's say:

I have a cell, A1. A1 has a function that does stuff.
I have another cell, A2. A2 contains a server name.

Now, normally what I would do here is simply create a hyperlink within the function field of cell A1 in this manner:

=HYPERLINK("http://"&A2&":8080/home","Home")

Since, the function field within cell A1 already contains another formula, I cannot do this (unless I'm unaware of a way to utilize two functions within a single cell).

I'm not very good with excel so I'm not sure how to write macros or utilize VB code so if these options can be avoided, that would be great.

**DonkeyOte** · 04-07-2010, 03:13 AM

You're going to need to provide a few more specifics I think ?

What for ex. is the existing function in A1 ?

Is it possible that the existing function be embedded into the HYPERLINK function - used to generate the friendly_name ? eg:

=HYPERLINK("http://"&A2&":8080/home",LEFT(A3,FIND(" ",A3&" ")-1))

With A2 being localhost and A3 being Ronald McDonald the output would be a hyperlink to http://localhost:8080/home but which appeared with text "Ronald"

the function used above (LEFT etc) is purely for demo.

**myCellEqualsNull** · 04-07-2010, 04:01 AM

I explained this all wrong

A1 has a function that searches another sheet within the same workbook for a particular ID and returns a server name that's associated with it (assuming the ID exists). What I would like to do is also create a hyperlink within that same cell that's based off the server name (as shown in my previous post).

DonkeyOte,
Your example helped:

=HYPERLINK("http://"&A2&":8080/home",LEFT(A3,FIND(" ",A3&" ")-1))

I simply appended the function within the hyperlink function as you suggested but in this manner:

=HYPERLINK("http://"&LEFT(A1,FIND(" ",A1&" ")-1)&":8080/home",LEFT(A1,FIND(" ",A1&" ")-1))

Much appreciated