Hi!

CopyPaste SpecialTranspose

Then, if needed, use T to C to further separate "Anytown,
TX 12345"

Biff

-----Original Message-----
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
.