| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Cell Shift
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| How do you delete a cell then shift cell up? | Excel Discussion (Misc queries) | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Threaded Mode
