Hi all,
I would like to copy and paste long texts from Word into Excel (Mac 2011) while preserving their colours (essential for the work I intend to do). The tricky thing is that everytime I paste a text, I want it to be in just one specific cell, and not several ones.
If I paste the text directly on right clicking on an excel cell it is going to preserve the colors BUT be divided into several cells (one cell per line break). Problem is that I don't know a way to merge these cells afterwards into one without deleting content.
If I double click on the cell and then paste, the text is going to be well spreaded into one cell, BUT without the colours. It takes then a lot of time to recolour the whole text, since I have to paste hundreds of cells like that.
Do you have any clue how to do this simple task?
I enclosed to this file templates:
-of the word file I want to copy from
-of the Excel file to want to paste to (row 2 being the ideal result)
Thank you very much in advance for your help!
All the best,
Antoine
Bookmarks