View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default How do i stop paste from spreading text across multiple cells ?

It's probably not spread across cells, but just displayed across cells.
Enter a space in the cell next to the one you paste in.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Chris W." wrote in message
...
Using Excel 2000:
Is there anyway to stop Excel's Paste method from taking multiline data

thats been put onto the clipboard and spreading it across multiple cells. I
need to copy large chunks of text and graphics and paste into distinct cells
for later retrieval.