Don't give up just yet.

Is there a pattern to the data?
For instance...does the address always begin 2 rows below the Owner
field?

If yes...Try this:
D1: Owner
E1: Addr1
F1: Addr2
G1: Addr3

B2:B65000 (numeric sequence from 1 through 64999)

C2: =SMALL(IF(LEFT($A$1:$A$65000,5)="Owner",ROW($A$1:$ A$65000 )),B2)
(Note: commit that array formula by holding down [Ctrl]+[Shift] and
press [Enter])

Copy that formula down as far as you need.
(That formula finds each successive occurrence of the Owner field)

D2: =INDEX($A$1:$A$65000,$C2)
E2: =INDEX($A$1:$A$65000,$C2+2)
F2: =INDEX($A$1:$A$65000,$C2+3)
G2: =INDEX($A$1:$A$65000,$C2+4)

Copy cells D2:G2 down as far as you need.

Is that something you can work with?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=500160