copy/pasting from document to spreadsheet

[Guest]

I put up this post a few days ago, but still have not been able to solve the
problem. I am copying/pasting various parts of a large microsoft document to
specific cells of an excel spreadsheet (i'm using an apple laptop). whenever
i move the text over from the document to excel, words that i have in bold or
italicized get automatically returned back to normal once they're in the
cell. is there a way i can correct this? i'd like the text to remain exactly
the way it is on the document. a previous reply suggested i try using a
notepad, but i don't have that option on my computer. thanks!

 

[Guest]

You cannot format individual words in a cell, just the entire contents of the
cell can be formatted. However, if you want to maintain the original
formatting you can insert the Word documnet text as and Object in the
workbook.

 

[Guest]

how do i insert the Word documnet text as an object in the
workbook (when you say 'workbook,' do you mean the excel spreadsheet)?

 

[Peo Sjoblom]

That's not true, you can certainly format a parts of a string in a cell

 

[Peo Sjoblom]

Edit > paste special as Microsoft word document object however it shouldn't
make a difference regarding formats, I have no problems keeping bold format
from word when pasted to excel
The idea behind pasting as object is that you can edit the document using
the source program

 

[Guest]

ok, then how do you format a parts of a string in a cell?

 

[Peo Sjoblom]

Either select parts (high light) of the text in the formula bar and format
it or press F2 and use the arrow keys to select the text and format it