We have the following in our spread sheet:







Column A
Column B

Column D
Column E
Column F
Column G
Column H

NAME
ADDRESS

TELEPHONE
Away Address
Away City & State
Away Zip
Away telephone

Alibrandi, Patricia
7455 Jacaranda Park Rd, S203

514-2840





Allard, Michael/Shirley Giquere
2635 Magnolia Park Ln, NY102

598-9268
57 Ridgetop Rd.
Wallingford, CT
06492
203-265-3164

Allard, Raymond & Zalita
7436 Plumbago Bridge Rd, N203

566-7762
18 State Rd.
Dannemora, NY
12429
716-532-0177

Allen, Philip & Marguerite
2615 Magnolia Park Ln, NW101

513-1771














We would like to prepare in the following format for a printed
telehone book. Can this be accomplished via a formula?



Would appreciate any suggestions to reduce work to accomplish this
format.















Column A
Column B

Column D





NAME
ADDRESS

TELEPHONE





Alibrandi, Patricia
7455 Jacaranda Park Rd, S203

514-2840














Allard, Michael/Shirley Giquere
2635 Magnolia Park Ln, NY102

598-9268






57 Ridgetop Rd., Wallingford, CT, 06492

203-265-3164














Allard, Raymond & Zalita
7436 Plumbago Bridge Rd, N203

566-7762






18 State Rd., Dannemora, NY, 12429

716-532-0177














Allen, Philip & Marguerite
2615 Magnolia Park Ln, NW101

513-1771