+ Reply to Thread
Results 1 to 1 of 1

Pasting with format from Word to Excel in a specific cell

  1. #1
    Registered User
    Join Date
    03-31-2014
    Location
    London, England
    MS-Off Ver
    Excel Mac 2011
    Posts
    6

    Pasting with format from Word to Excel in a specific cell

    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
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 07-12-2013, 09:17 AM
  2. data from excel to word in specific format
    By janavi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-26-2012, 06:20 AM
  3. Pasting several excel ranges into Word - Format Problem
    By mccrimmon in forum Word Programming / VBA / Macros
    Replies: 1
    Last Post: 07-11-2011, 09:28 AM
  4. Format Specific Word in Cell
    By cgerace19 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-18-2009, 01:27 AM
  5. [SOLVED] Link from a specific Cell in Excel to a specific para. in Word
    By CathyK in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-10-2006, 11:45 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1