How to import address list tables into Excel

  • Thread starter Thread starter daniel.mogstad
  • Start date Start date
D

daniel.mogstad

I have an address list in Word that looks like this:

____________________________________
| Mr Smith |
| 34 swanky st. |
| Bufftton 3454-123 |
| UK |
|___________________________________|
| Fat Bread Co. |
| Attn. Justin Jock |
| 453 Long Drive |
| Staten Island |
| 232434 |
| US |
|___________________________________|

and on and on.

I need to get this into Excel, for a proper address list with name in
1st column, address in 2nd and so on.

Any suggestions would be greatly appreciated.

Daniel
 
Daniel,

Copy your data table into column A, starting at row 2. Then in cell B2, enter the formula

=IF($A1="",IF(AND(A2<>"",OFFSET($A2,COLUMN()-COLUMN($A2),0)<>""),OFFSET($A2,COLUMN()-COLUMN($A2),0),""),"")

and copy it to the right 7 or 8 columns, then copy down to match your data table. Copy all those
cells, paste as values, then sort based on whichever column suits you. Then delete column A and all
the blank rows.

HTH,
Bernie
MS Excel MVP
 
I'm sorry - I wrote without thinking. DON'T delete column A - just the rows where column B is
blank.

HTH,
Bernie
MS Excel MVP
 
Back
Top