DiscussWorldIssues - Socio-Economic Religion and Political Uncensored Debate - View Single Post

**amannddo** · 10-28-2005, 08:06 PM

It pastes it into one cell, not all of them. I've tried selecting a region of cells and the entire document while pasting but it didn't work.

A friend of mine said something about being able to import it as tab seperated vaules...I'm gonna see if I can get that to work

are you sure it's pasting it into one cell? I just did it and it pasted it into all the cells, it got rid of the formatting so that you can't see the cell boarders but it did paste into multiple cells.(for the heck of it I even highlighted the entire document and went to format and borders and put borders on the inside and outside to be sure)

if not there may be a setting on your excel that is messed up. (sometimes you have to use text to.(grid?)...(I can't remember the name, it's up in tools, at work don't have excel here)

10-28-2005, 08:06 PM	#6
amannddo Join Date Oct 2005 Posts 410 Senior Member	It pastes it into one cell, not all of them. I've tried selecting a region of cells and the entire document while pasting but it didn't work. A friend of mine said something about being able to import it as tab seperated vaules...I'm gonna see if I can get that to work are you sure it's pasting it into one cell? I just did it and it pasted it into all the cells, it got rid of the formatting so that you can't see the cell boarders but it did paste into multiple cells.(for the heck of it I even highlighted the entire document and went to format and borders and put borders on the inside and outside to be sure) if not there may be a setting on your excel that is messed up. (sometimes you have to use text to.(grid?)...(I can't remember the name, it's up in tools, at work don't have excel here)
	Quote