GraffikPleasure
New member
- Joined
- Sep 16, 2016
- Messages
- 6
- Reaction score
- 0
- Points
- 0
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)
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?
Attached I have the file setup I'm using. View attachment TEST.xlsx
THANK YOU
I need to insert editors and their affiliation like this: John doe (USA), Jane doe (Africa), and Frank doe (Canada)
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?
Attached I have the file setup I'm using. View attachment TEST.xlsx
THANK YOU