![]() The following Excel formulas will get you from this list to an Excel spreadsheet you can mail merge from with Word. Open a brand new excel spreadsheet and copy / paste in your list of names and addresses into the first sheet. In the “name” part, we want everything up to the first comma (Mr and Mrs X, Some House, Some street…), so in the box under “Name” we enter the following formula: Note you may have more than 6 or 7 in the address, but if you do, there’s a chance your labels won’t fit anyway! Also, you can try to be clever and put “City” “State” “Postcode” etc, but only if your addresses are very regular, and all in the same country – mine usually are not! Step Four – Import The Content Using Formulas Put the following in the top of each column: Name, Address 1, Address 2, Adress 3, Address 4, Address 5, Address 6 Step Two – Start a New SheetĪt the bottom of the spreadsheet, it should read “sheet 1” you want to press the “+” symbol and add a sheet 2 – this is where we’ll be building the address spreadsheet. ![]() Then we drag down the little right hand bit to apply this to every cell which has a corresponding address over on sheet 1.
0 Comments
Leave a Reply. |