copy/pasting from document to spreadsheet

[gregp22]

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]

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]

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]

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

--

Regards,

Peo Sjoblom


"Kevin B" <[email protected]> wrote in message
news:[email protected]...
> 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]

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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]

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" <[email protected]> wrote in message
news:[email protected]...
> 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]

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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!
>>
>>
>>