Did you want the address to end up in a single cell or in several cells
across several columns (one for each row used)?

--
Rick (MVP - Excel)


"Barry Freeman" wrote in message ...
Hope you can help. I have a number of spreadsheets containing customer
details and addresses. The details for each customer are contained in a
single row, but the addresses read in a single column,eg.

Name | ID | Address | Org. | Currency |
__________________________________________________ _
J.Doe | 23 |101 Easy Street | 5221 | Euro |
|Nowhere Lane |
|Deadville |

Some addresses are longer than others. I can move the Address column to
the end of the spreadsheet to prevent misplacing the Org. and Currency.
The spacing between each customer varies, between 1 and 10 blank rows.
Some code i have tried requires fixed spacing.

Can you suggest some code that will allow me to move the rest of the
address into the same row? I have to do this for nearly 18,000 customers!!


Submitted via EggHeadCafe - Software Developer Portal of Choice
Job Interview And Resume Tips for Developers
http://www.eggheadcafe.com/tutorials...nd-resume.aspx