how do I put rows in excel to seperate, one addresse from another.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Betty F - 29 Sep 2004 15:45 GMT

I have a list of addresses that I would like to seperate by rows,
example:Golden Bay Federal Credit Union
PO Box 127 Bldg 556
Moffet Field, CA
Golden Valley Federal Credit Union
Manteca, CA 95336

I would like to seperate each address with a blank row, and where there are
one or two lines of address, with 2-3 blank line to make the format of four
line in the address including the blank.

Thanks in advance

Reply to this Message

Anne Troy - 29 Sep 2004 17:37 GMT

Hi, Betty. Mail merge with Word!
**** Hope it helps! ****

~Dreamboat
Excel VBA Certification Coming Soon!
www.VBAExpress.com/training/
********************************

> I have a list of addresses that I would like to seperate by rows,
> example:Golden Bay Federal Credit Union
[quoted text clipped - 8 lines]
>
> Thanks in advance

Reply to this Message