Hyperlink Domain Appending

**altrae** · 12-09-2010, 12:55 PM

I am trying to make hyperlinks out of multiple cells or even hardcoding the domain name and appending the cell content to it.

Example:
=hyperlink("[http://www.domain.com]+A1+B1",C1)
=hyperlink("A1+B1+C1",D1)

I don't know if this is possible, but I am not that familiar with all of the formatting options available as I don't use Excel that often.

Any ideas on how I can make this work?

**6StringJazzer** · 12-09-2010, 01:02 PM

I think you want this

Please Login or Register  to view this content.

Here are the problems with your example:

Use "&" to concatenate strings. "+" is for addition only.

If you put cell references inside quotes, they are going to be interpreted as a string.

I don't know what you're trying to do with the [brackets] but they shouldn't be there.

**altrae** · 12-09-2010, 01:19 PM

Originally Posted by 6StringJazzer

I think you want this

Please Login or Register  to view this content.

Here are the problems with your example:

Use "&" to concatenate strings. "+" is for addition only.

If you put cell references inside quotes, they are going to be interpreted as a string.

I don't know what you're trying to do with the [brackets] but they shouldn't be there.

That was exactly what I was looking for. Thank you!

The brackets were only being used because of some examples I found here: http://office.microsoft.com/en-us/ex...010096304.aspx

Obviously I didn't quite understand the formatting.