Hi all,
I am making an Excelsheet to easily create UTM-codes for content tracking. Now i'm stuck with the following problem:
I have created two different sheets, one with the UTM-generator and the other one with the definitions used. These definitions are seperated in two values a full name and a code, for example the business unit is marked like this: Full name= Businessunit1 Code= Bu1. Now i have created multiple dropdownlists using the full names of the definitions and I want to use a Conconate formula to get all the codes concenated into one term.
So for example I have someone who wants to generate a code for Businessunit: Businessunit1, Source: LinkedIn I want to have it conconated like: Bu1Lin and not Bussinesunit1LinkedIn, which code should i use to create this?
Thanks in advance!
I am making an Excelsheet to easily create UTM-codes for content tracking. Now i'm stuck with the following problem:
I have created two different sheets, one with the UTM-generator and the other one with the definitions used. These definitions are seperated in two values a full name and a code, for example the business unit is marked like this: Full name= Businessunit1 Code= Bu1. Now i have created multiple dropdownlists using the full names of the definitions and I want to use a Conconate formula to get all the codes concenated into one term.
So for example I have someone who wants to generate a code for Businessunit: Businessunit1, Source: LinkedIn I want to have it conconated like: Bu1Lin and not Bussinesunit1LinkedIn, which code should i use to create this?
Thanks in advance!
