Forum Discussion
excel merge two columns
I have a data file of contacts with first names of 1 contact a second file of a second contact - if there is one. I'm doing a mail merge and wanted the option of "Dear Contact1 & Contact2,". But, not...
I don't understand why you would want to add an if condition. If the middle name is empty, it wouldn't result in an error, right?
You could try this:
| first name | second name | your formula |
| Paul | Peter | =A1&" "&IF(ISBLANK(B1);"";B1) |