![]() |
Mail Merge
We are trying to do a mail merge, but the address is in one cell, is there a
way of trying to spilt the one cell down into 5 different cells ? |
Mail Merge
There are several ways.
If the data is separated by a delimter (e.g. a comma after first name, last name, street, etc.) you can easily use DataText to Columns. You can still use it if the data isn't that clean but you may have to start with fixed length to get as close as you can, then cleaning it up manually. The other option is to move it to Word and do a series of Find and Replace actions to get a delimiter in there (after convering the table to text), then convert back to a table and copy back into Excel. Annoying and a last resort, but I've had to do it many times. Hope these get you started! --Elizabeth -- ERR229 "boostbar" wrote: We are trying to do a mail merge, but the address is in one cell, is there a way of trying to spilt the one cell down into 5 different cells ? |
All times are GMT +1. The time now is 01:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com