Remove space if a merge field is blank RRS feed

  • Question

  • Doing letter mail merge to employees. Not all employees have a middle initial so an additional blank space is created in the final merge. I want the space to close up so that there is only one space between first and last name. Used the IF THen ELse option but that's not correct - it prompts for additional text, does not allow deleting a space...unless there's special syntax for that and I don't know what it is. Help! (using Microsoft Word 2010, data from Excel 2010)
    • Edited by IreneB2 Friday, September 14, 2012 8:50 PM
    Friday, September 14, 2012 8:48 PM


All replies