Hi
then for a non-VBA solution. enter the following in A1 on your second sheet
8assuming your sourece data starts in A1 on a different sheet called
'data'):
=OFFSET('data'!$A$1,(ROW()-1)*5+COLUMN()-1,0)
and copy this 5 cells to the right and down.
After this copy this range and insert it with 'Edit - Paste Special -
Values' to remove the formulas

--
Regards
Frank Kabel
Frankfurt, Germany

Jeff Brown wrote:
yes, they all have 5 rows per record
thanks,
Jeff

"Frank Kabel" wrote:

Hi
do you always have the same amount of rows per record?

--
Regards
Frank Kabel
Frankfurt, Germany

Jeff Brown wrote:
Hi,
How can I take text entered like this:
Mike Smith Toyota
123 Main St
Anytown, TX 12345
phone 713 222 1212
fax 713 222 2121

...and move it to where every address element (name, street, city,
etc.) is in its own column? Text to Columns obviously won't work,
and I've had no luck trying to make a macro to do it.
Thanks,
Jeff