Try doing Paste Special instead, then select Transpose.
By highlighting and copying a name and address in a block format, I then paste it to an XL spreadsheet the result of course is everything all goes into one column.
How can I (easily) force the result to occupy separate columns IPO rows?
Try doing Paste Special instead, then select Transpose.
Thanks That worked
Bookmarks