You are here:

Excel/Excel mail label question


I have been asked to volunteer my time in printing and mailing for a charitable organization  The list provided me is in Excel and the top row contains  names addresses etc but about 200 rows down there is a header as follows:   

Prefix   First Name   Middle Initial   Spouse   Last Name   Address    City   State   Zip Code   Company    
Co. Address Line    Co. City   State   Co.Zip code   

All in all about 14 fields and the problem is that in many cases the company address (where it is a co.) is sometimes under "co.address", and in other cases under "address. Same goes for city, state zip. In other words it's all mixed up. If I were to separate the list leaving the last field as "zip", and do the same thing with the co info to the right, I am left with blank areas in each. The person who created this tells the customer that they printed out the labels from this. I would kike to find out how this was done. Of course I can easily move the field header up to row #1, but how do I handle all the blank fields where printing  is concerned?

HOPEFULLY you now had a working answer, as I know you asked me for the answer as well - question found in question pool as other expert was either unable or unwilling to help.  IF it hasn't been resolved do let me know by posting a follow up question and I'll do my best to help further.
About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here


All Answers

Answers by Expert:

Ask Experts


Aidan Heritage


I have provided first hand support since `95 for Microsoft Office majoring in Word and Excel - support for all versions from 2 onwards. I'm based in the UK, so please allow for time differences when asking me questions from other parts of the world! As AllExperts closes down, just google me to find my details - I will still be around answering questions!


My background is in the insurance industry and call centre areas, but have been called upon to provide many varied solutions.

I'm educated to UK A level standard, but as I left school some 30 years ago that is rather irrelevent - university of life has provided more of a background!

©2017 All rights reserved.

[an error occurred while processing this directive]