Referencing directory from inside function

[benAz]

I don't know if my title accurately describes my problem, but I don't know how else to describe it.

I have two cells. A1 has the contents ="c:\temp", B1 has the contents ="test".
I want to create a hyperlink to this, so if I directly wrote the function call it would be =hyperlink("c:\temp\test","test"). My question is how to join cells A1 and B1 in the function to create the same effect. I will be reusing this many times, and the contents of cells A1 and B1 will be changing, so it will be a huge time saving if I can just change them in one place.

thanks

[khunt]

Several ways to handle it I think, one using the CONCATENATE function

=CONCATENATE(A10,"/",A11)

or simply

=A1 & "/" & B1

[sglife]

This should be the correct formula .

Please Login or Register  to view this content.