Copy formatted text from Word to a single excel cell

[Sharada]

Hi,

I have an MS -Word document that is a compared version to identify changes between 2 source files. Hence there are red font+strikethrough for deletions and green font for insertions.

The issue is I want to paste this entire content into a single cell in Excel without losing the formatting (strikethrough/green fonts). Have tried converting this text into a table in Word and then inserting in Excel, however unable to do so. If I just paste directly into Excel, it splits the paragraph into multiple rows and if I press F2 and paste into a single cell, all the formatting is gone.

Is there any way to accomplish this without losing the format. Sample file attached.

Will be extremely grateful if this gets resolved

Thanks!

 

[Ashhu]

Dear Sharada
In 2010 Office version , we can do that. See image n excel copy also attached.

Thanks

 

[bobhc]

Click in the cell and from the pop up list choose paste "keep original formatting"

 

[Sharada]

Thank you so much for your response Asshu. That helps! However, we are still working with Excel 2007. Hope there's some way to do it in 2007 too (I'm sure there must be . One query, if this is saved as a 2007 compatible excel file, hope the formatting won't be lost.

Thanks again for this. Maybe I should insist on the company switching to the 2010 version

 

[Ashhu]

Unfortunately i tried all option in 07, but unsuccessful. If you save in 2010 you can open in 2007, separate save is not required. Format will remain unchanged. The attachment which i sent in my previous reply done in same way.

Yeah, its wise to upgrade. Good luck.

Thanks for joining group. we hope we will see you more to upgrade your excel skills.


-Ashwin

 

[Sharada]

Thanks Ashwin for all your help. Really appreciate it. Certainly! Excel is limitless and the learning is immense. I'm just a novice