I have data in the following format and would like to convert into an Excel
spreadsheet for use as mail merge database

Mr Chris Acton
ADH Services Ltd
Unit 5 The Oaks Down End
Crediton
Devon
EX17 1HN
Mr Peter Alexander
Mains Of Mause
Blairgowrie
Tayside
PH10 6TE
Mr James Anderson
Bowmer & Kirkland Ltd
High Edge Court Church Street
Belper
Derbyshire
DE56 2BW

If the addresses were only three lines then I could use the following
method. However some addresses have 5, 6 or 7 lines. Can anybody help get it
in the right format for a mailmerge?

In B1 enter this formula =INDEX($A:$A,(ROWS($1:1)-1)*3+COLUMNS($A:A))
Drag/copy across to D1.
Select B1:D1 and drag/copy down until zeros show up.
Select columns B:D and copy.
EditPaste Special(in place)ValuesOKEsc
Delete Column A

--
Nash