| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I convert a single column of addresses into rows for export
I have a list of addresses that are all in column A that I need to transform
into rows to export into ACT. I am a total newbie to macros and VB. The addresses are all seperated by a cell with the number 100. An example of the list follows. There are about 350 addresses. 100 Realtor Sherry Abell Realty One Medina 3565 Medina Rd Medina OH 44256 877 7233211 8777233211 100 Realtor Nancy Adams Kovack Realty Inc - Wadsworth Ste 105 1392 High Street Wadsworth OH 44281 800 8378883 100 Realtor Terry Albright Smucker Realty 6605 Smucker Dr. Westfield Center OH 44251 330 8875286 100 Realtor Mary Anderson Realty One Medina 3565 Medina Rd Medina OH 44256 877 7233211 8882010910 Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change a Column list into multiple rows & columns | Excel Worksheet Functions | |||
| Return Single Row of Numeric Data to Single Column | Excel Worksheet Functions | |||
| Multiple rows of data on a single axis (charting) | Charts and Charting in Excel | |||
| how do I easily convert a single column of text (multiple rows si. | Excel Discussion (Misc queries) | |||
| Change the width of a single column in a column chart | Charts and Charting in Excel | |||
Threaded Mode
