CODEWITHSUNDEEP
hyperlinkexcel-formula
cgallant
cgallant

Reputation: 1

Creating new link in excel

In Excel I am trying to have it automatically generate a new URL link (column D, row 3). Using a base URL link (listed for example purposes below as http://vxyz/ in column A, row 3) and then adding two additional non-numerical pieces of information (client name & campaign=columns B and C, row 3). What formula would I use to generate this type of information? Any help would be greatly appreciated!

A              B               C            D
Base URL       client name     Campaign     New URL

http://vxyz/   jsmith          e1v1         ?

Upvotes: 0

Views: 57

Answers (2)

eliberator
eliberator

Reputation: 139

the formula is: 

=HYPERLINK(CONCATENATE(A3, B3, C3))

Upvotes: 1

Gyrocode.com
Gyrocode.com

Reputation: 58930

Excel 2013

ENCODEURL is needed to encode special charactes, but it's only available in Excel 2013.

=CONCATENATE(A2,"/",ENCODEURL(B2),"/",ENCODEURL(C2))

Upvotes: 0

Related Questions