Without knowing how the individual addresses are separated, it is impossible to separate them.

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

dear sir

the individual addresses are separated by :
Title: Mrs
Name: Johan
address1: Block 1 - Heavens Flat 404
address2: Cantonment area
address3: City
Zip: 5600070

as i mentioned earlier, there are three columns
with 3 to 5 rows for each address.

will transpose method help? if so, please help me
how can it be done.

thanks

m s narayanan