Dynamic hyperlink in the same cell as the data?

[sabot7726]

I took a look around and noticed I can use the HYPERLINK command to link to a URL plus the contents of a different cell, such as something like =HYPERLINK(www.blah.com&A1).

My question is, can I do a dynamic hyperlink that is smart enough to append whatever data is in the same cell to be the final part of the URL? Or do I HAVE to have another column where the hyperlink command is pointing to the first column as the variable?

For example I have a single column with either nothing in it or a 4 digit number. The 4 digit number is also the end of the URL I want it to link to. For example if the column says 1234, I would want it to go to "www.example.com/CSIssue_View.asp?IssueNbr=1234"

Thanks for any assistance!

 

[DonkeyOte]

Perhaps:

=HYPERLINK("www.example.com"&REPT("/CSIssue_View.asp?IssueNbr="&$A1,$A1<>""))

 

[sabot7726]

Hrm I tried that and it gave a circular reference error. Does it matter that I adjusted it to be the real field instead of A1?

I used:
=HYPERLINK("www.example.com"&REPT("/CSIssue_View.asp?IssueNbr="&$C35,$C35<>""))

 

[DonkeyOte]

I think I missed a fundamental point... if you're the 1234 appears in the cell you wish to be a Hyperlink then you would need to use VBA to convert ... else, as you say, have the hyperlink in a different cell to the 1234.