Hi all,

A simple query I hope.

I need to turn 30 pages of address label text in word, into mail merge
cells. If I copy the document and past into excel the fields paste
vertically, but is it possible to paste across. I am aware of
delimiters but they only seem to work when there is a space or comma,
and there isnt in this example.

thanks

Andrew


--
ajw150
------------------------------------------------------------------------
ajw150's Profile: http://www.excelforum.com/member.php...fo&userid=8020
View this thread: http://www.excelforum.com/showthread...hreadid=560173

I don't know if this works, but once you've copied your address, try
Paste Special Transpose.

Alternatively, paste the data in so it initially goes in vertically,
then copy it within the Excel document and do the same Paste Special
Transpose operation.

HTH,

Samuel T


--
SamuelT
------------------------------------------------------------------------
SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501
View this thread: http://www.excelforum.com/showthread...hreadid=560173

Nope - the first option won't work. The second might still...


--
SamuelT
------------------------------------------------------------------------
SamuelT's Profile: http://www.excelforum.com/member.php...o&userid=27501
View this thread: http://www.excelforum.com/showthread...hreadid=560173