How to import address list tables into Excel

[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

 

[Bernie Deitrick]

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

 

[Bernie Deitrick]

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