ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   copy/pasting from document to spreadsheet (https://www.excelbanter.com/new-users-excel/79454-copy-pasting-document-spreadsheet.html)

gregp22

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!

Kevin B

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!


gregp22

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!


Peo Sjoblom

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!




Peo Sjoblom

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!




gregp22

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!





Peo Sjoblom

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