Creating a hyperlink in column
I am wanting to have Excel link to a website based on values in a column. For
example, 12345678 is the first value in column R:R, or R2. I want Excel to
convert these values to a link to
"http://www.somewhere.com/abscd.asp?addrs=12345678", but I only want to see
12345678 in that column.
Is this possible? Any help you provide is appreciated.
|