Don, if the data is all in one column and you want to separate have a look
at data text to columns, if the data is allready in columns and you want to
print it on lables I would do a mail merge with word,

For help on Word mail merge using Excel as the data source have a look here

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...DataSource.htm


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Don Lloyd" wrote in message
...
Hi all,

Given a sheet with many rows of name, address data, are ther any
"standard"
routines for converting / printing the data in address format. ?

Don