vzachin
07-17-2007, 10:43 AM
Hi,
this is not a vba question but i'm hoping that someone can help me with this question.
i'm copying one line of data which consists of 4 fields from a mainframe application and want to paste all the data into cell A1. instead, the data is spread out across A1,B1,C1 & D1.
if i do a Paste Special,Text then all the data appears in one cell A1.
Is there any other way of pasting this data without doing a Paste Special,Text?
thanks
zach
this is not a vba question but i'm hoping that someone can help me with this question.
i'm copying one line of data which consists of 4 fields from a mainframe application and want to paste all the data into cell A1. instead, the data is spread out across A1,B1,C1 & D1.
if i do a Paste Special,Text then all the data appears in one cell A1.
Is there any other way of pasting this data without doing a Paste Special,Text?
thanks
zach