| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I remove a blank space on a set of address labels when u.
I am trying to print labels from an excel mailing list. When the label
formats for printing there is an extra space : Name Address City State zip how can I delete that space and apply it to all the labels ? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I remove a blank space on a set of address labels when u.
Hi Denise,
Assuming each piece of data is on a separate row and no blank between 2 labels: Eg: A1: Name A2: Address A3: <blank A4: City State zip A5: Name <---- no blank cell between A4 and A5 A6: Address A7: <blank A8: City State zip -Select the column of data -menu Edit Goto, click the Special button and choose Blank. Now, all the blank cells in the column are selected -menu Edit Delete, choose Entire Row. Regards, Sebastien "Denise" wrote: I am trying to print labels from an excel mailing list. When the label formats for printing there is an extra space : Name Address City State zip how can I delete that space and apply it to all the labels ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove blank space in front of text in multiple cells at once | Excel Discussion (Misc queries) | |||
| How to remove blank space? | Charts and Charting in Excel | |||
| Remove Civic numbers in Street Address, move to previous blank cell | Excel Worksheet Functions | |||
| I want a blank space on a worksheet when the question is blank? | Excel Discussion (Misc queries) | |||
| Excel 2003 and Labels (NOT Address Labels) | Excel Discussion (Misc queries) | |||
Linear Mode
