Excel 2007 version

[Maggoty]

I have now had the above version of Excel loaded onto my pc. However when I come to do labels if there is a space in the address (ie address line 3 or county) then that line on the label becomes a blank. so I have in effect

Mr John Smith
1 Acacia Avenue
Walthamstow

London

E11


And like wise for any of the address records that do not have 4 lines of address or county. How do I tell the pc that the are to skip that line if blank. I know we could do that on the previous version.

Cheers in anticipation

x

[tamborine]

If this was on Word labels I would delete from Walthamstow to London, delete again to E11. The blank lines are often for dates, references & other data.

You could copy & paste address from Excel to Word.

[ABerrant]

Transfer of data between Excel and Word is what Mail Merge was developed for.

[Vagrant]

Is this a mail merge with Excel feeding Word?

If so, the problem is likely with Word, not Excel.
With Word 2007, the default paragraph style includes a double line space after.
Either change the default paragraph style to reduce the space after, or use Shift+Enter after Walthamstow so that a new line is inserted within the paragraph rather than Enter which creates a new paragraph.

[Maggoty]

Not sure any of that helps. I know that all I have to do in the excel spreadsheet is to 'move' the address lines over so if the address is 1 Acacia avenue, London, N1 1AA
London would now be in address 2 and the postcode would be in address 3. But I need to print mailing labels from a database of thousands on a weekly basis, so this will get tedious after a while. On the old Windows there was an option to ignore blank fields which meant that the town could stay in the 'town' field and it would automatically delete blank fields. there must be this option in the new windows - just can't find it.

x