Does anyone know a formula to combine several cells into a text in one cell with mixed delimiters between words?
Cell A1 - First Name
Cell B1 - Last Name
Cell C1 - Job Title
Cell D1 - Company
I would like to combine the first two cells with a space and the rest with a comma followed by a space. My target for the above cells is:
"First Name Last Name, Job Title, Company"
Does anyone know a formula for this please?