If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|