Putting cell contents into a hyperlink

[wiser3]

I'm trying to use the =HYPERLINK function to link to a web site where the domain name is always the same but the sub dir is coming from another cell. Example

Here's my current formula that doesn't work:
=HYPERLINK("

http://www.domainname.com/$B1",

"Web Link")

| A B
----------------------
1 | Web Link subdir
2 | Web Link difdir

So that when you click the "Web Link" in cell A1 your browser opens to

http://www.domainname.com/subdir

Likewise clicking cell A2 opens your browser to

http://www.domainname.com/difdir

 

[SkipVought]

You're close
[tt]
=HYPERLINK(Indirect("

http://www.domainname.com/"&$B1),

"Web Link")

[/tt]


Skip,

_{[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount!}

 

[wiser3]

Thanks, i got it to work although i had to modify your line a little, by removing the "Indirect".