Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Trying to copy and paste line of text into multiple cells

I have a text file that has sports pointspread data, and i need to
just simply copy a line of characters such as:


L -15' 17-14 u44

...and then make sure they go in four columns (as i highlight the
columns before entering) . But when i try doing this, i get the
message saying
"Data is not the same size as the selected area" and just puts it all
in one cell

????
NS
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,393
Default Trying to copy and paste line of text into multiple cells

Select just one cell in the target range; Excel will look after the rest
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

".Net Sports" wrote in message
...
I have a text file that has sports pointspread data, and i need to
just simply copy a line of characters such as:


L -15' 17-14 u44

..and then make sure they go in four columns (as i highlight the
columns before entering) . But when i try doing this, i get the
message saying
"Data is not the same size as the selected area" and just puts it all
in one cell

????
NS



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
Copy and paste same text in multiple fields- excel 2007 G Excel Discussion (Misc queries) 4 October 2nd 08 03:19 PM
macro copy/paste data from multiple cells to multiple cells Diana Excel Discussion (Misc queries) 0 July 10th 06 09:24 PM
how can we copy cells comments text and paste to cells שי פלד Excel Discussion (Misc queries) 3 December 12th 05 05:16 AM
copy/paste excel to texteditor -> multi-line text cells gain unwanted double-quotes niz Excel Discussion (Misc queries) 1 October 14th 05 02:06 PM
How to copy and paste same formula in multiple cells? Amanda Excel Worksheet Functions 1 June 30th 05 04:16 PM


All times are GMT +1. The time now is 07:33 PM.

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

About Us

"It's about Microsoft Excel"