(Title suppose to say "Paste" not "Past" unfortunately cannot edit thread titles)
This question may lean a little more on the "Word" side, but the end result will be used in Excel.
I am using version 2003 but I imagine this options should be available in all versions.
If I take a text document (.txt file format) and open it up in "Notepad" or "WordPad" and then copy text from this document and paste it into an Excel spreadsheet that has a color fill background, the text will paste perfectly into those cells no altering the color background at all.
If I open up a .txt document with Word and I try to do the same thing, when I paste that text into my Excel spreadsheet it removes the color fill background and makes it white, in essence removing the cells formatting.
"Styles and Formatting" is set at "Plain Text".
I am aware of "Paste Special" which is not what I am looking for.
What I am looking for is....
1.) Some kind of setting / formatting option within Word that makes it so that when Word copies text from a .txt file that the formatting does not come along with it (which in my case as mentioned in example above is removing the background color)
2.) Would also like this ability to apply this setting / formatting option to Word Documents (.doc) as well if possible.
Thank You to anyone who reads this
This question may lean a little more on the "Word" side, but the end result will be used in Excel.
I am using version 2003 but I imagine this options should be available in all versions.
If I take a text document (.txt file format) and open it up in "Notepad" or "WordPad" and then copy text from this document and paste it into an Excel spreadsheet that has a color fill background, the text will paste perfectly into those cells no altering the color background at all.
If I open up a .txt document with Word and I try to do the same thing, when I paste that text into my Excel spreadsheet it removes the color fill background and makes it white, in essence removing the cells formatting.
"Styles and Formatting" is set at "Plain Text".
I am aware of "Paste Special" which is not what I am looking for.
What I am looking for is....
1.) Some kind of setting / formatting option within Word that makes it so that when Word copies text from a .txt file that the formatting does not come along with it (which in my case as mentioned in example above is removing the background color)
2.) Would also like this ability to apply this setting / formatting option to Word Documents (.doc) as well if possible.
Thank You to anyone who reads this
Last edited by a moderator:
