Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Spreading dates evenly in a row of cells OHNESORGE Excel Discussion (Misc queries) 2 March 12th 09 02:26 PM
Trying to copy and paste line of text into multiple cells .Net Sports Excel Discussion (Misc queries) 1 October 21st 08 02:10 AM
Spreading 1 large number evenly into several cells Dos Equis Excel Worksheet Functions 0 October 4th 06 05:50 PM
import /paste -stop automatic conversion of text 05-12345 to date artech Excel Discussion (Misc queries) 1 August 20th 06 09:09 PM
macro copy/paste data from multiple cells to multiple cells Diana Excel Discussion (Misc queries) 0 July 10th 06 09:24 PM


All times are GMT +1. The time now is 04:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"