I'm having to use the wizard to do mail merges with excel/csv files. I need to know how to remove spaces in a filed. For example if we have 12 spaces for 'First Name' and have Bob there Word treats the remaining 8 spaces as being populated. We can't change how the csv file is created but need to remove any unwanted null/blank spaces within certain fields. Any ideas?