Ok, so I'm doing mail merges for html email templates. I have these things so close to being 100% but I just need to do the following:
I need to insert editors and their affiliation like this: John doe (USA), Jane doe (Africa) and Frank doe (Canada)
The first and last names are in column A, C, and E. The affiliations are in B, D, and F.
How can I set myself up in Excel to add the parenthesis IF there is a second or third editor. And how can I make the "and" be inserted when there is only two or three editors where it needs to go?
Aucun commentaire:
Enregistrer un commentaire