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:
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?