ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Mail Merge (https://www.excelbanter.com/excel-discussion-misc-queries/64769-mail-merge.html)

boostbar

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 ?

ERR229

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