curiouswebster
asked on
Excel: Need formula(s) to build a web URL from field values
I have a typical Excel for Contacts with columns for FName, LName, Street1, Street2, etc...
and I need to create a single URL per contact that looks something like:
https://mydomain.com/mailing?mc=1234&fc=456&uc=1092949&fname=JOHN&lname=SMITH
Where the URL is made up of column data for that row.
How do I create a formula in Excel to create this string?
Is see a problem where & is a required character for Excel and for the URL. Should I use a placeholder Char, then replace with '&' at the very end?
Also, I would also like to fix the case, so JOHN becomes John?
Thanks
and I need to create a single URL per contact that looks something like:
https://mydomain.com/mailing?mc=1234&fc=456&uc=1092949&fname=JOHN&lname=SMITH
Where the URL is made up of column data for that row.
How do I create a formula in Excel to create this string?
Is see a problem where & is a required character for Excel and for the URL. Should I use a placeholder Char, then replace with '&' at the very end?
Also, I would also like to fix the case, so JOHN becomes John?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.