![]() |
copy/pasting from document to spreadsheet
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! |
copy/pasting from document to spreadsheet
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. -- Kevin Backmann "gregp22" wrote: 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! |
copy/pasting from document to spreadsheet
how do i insert the Word documnet text as an object in the
workbook (when you say 'workbook,' do you mean the excel spreadsheet)? "Kevin B" wrote: 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. -- Kevin Backmann "gregp22" wrote: 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! |
copy/pasting from document to spreadsheet
That's not true, you can certainly format a parts of a string in a cell
-- Regards, Peo Sjoblom "Kevin B" wrote in message ... 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. -- Kevin Backmann "gregp22" wrote: 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! |
copy/pasting from document to spreadsheet
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 -- Regards, Peo Sjoblom "gregp22" wrote in message ... how do i insert the Word documnet text as an object in the workbook (when you say 'workbook,' do you mean the excel spreadsheet)? "Kevin B" wrote: 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. -- Kevin Backmann "gregp22" wrote: 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! |
copy/pasting from document to spreadsheet
ok, then how do you format a parts of a string in a cell?
"Peo Sjoblom" wrote: That's not true, you can certainly format a parts of a string in a cell -- Regards, Peo Sjoblom "Kevin B" wrote in message ... 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. -- Kevin Backmann "gregp22" wrote: 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! |
copy/pasting from document to spreadsheet
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 -- Regards, Peo Sjoblom "gregp22" wrote in message ... ok, then how do you format a parts of a string in a cell? "Peo Sjoblom" wrote: That's not true, you can certainly format a parts of a string in a cell -- Regards, Peo Sjoblom "Kevin B" wrote in message ... 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. -- Kevin Backmann "gregp22" wrote: 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! |
All times are GMT +1. The time now is 11:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com