Results 1 to 4 of 4

Copying Word Table to Excel without Breaking one cell into multiple cells

Threaded View

  1. #1
    Registered User
    Join Date
    01-20-2016
    Location
    288
    MS-Off Ver
    2016
    Posts
    29

    Copying Word Table to Excel without Breaking one cell into multiple cells

    I'm not sure if this is the correct forum for this question. If not, please let me know where i should post.

    So, here's the deal. I'm pasting a column from Excel into outlook to run through a proprietary program from my company. It paste fine into outlook as a table (example spreadsheet). But when i try to copy and paste back into excel it breaks each line/sentence, from one of the cells in the table, into individual cells with a blank cell in between each row. I also need to keep the color formatting for the phone numbers in each cell.

    I've tried find and replace (CTRL-H) to locate ^1 and replace with ^p, ^v, etc. then paste into excel and use the same method to replace ^p with nothing. Doesn't work. My brain is fried. I've been trying to figure this out for a few hours today and just can't seem to get it to work.

    Any and all help is greatly appreciated.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Unwanted table/end of cell markers when copying from Excel to Word bookmark
    By steve61 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-18-2014, 12:39 PM
  2. Copying from Excel to a table in Word
    By woolleyy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-14-2013, 12:39 PM
  3. Breaking up string of text in 1 cell into multiple cells
    By dizzle in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-02-2013, 05:26 AM
  4. Breaking up information in one cell into multiple cells
    By NMen in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-01-2013, 12:48 PM
  5. Replies: 0
    Last Post: 01-07-2013, 09:15 PM
  6. Excel - allow cell margins similar to Word table cells
    By Liz Geho in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-05-2006, 02:25 PM
  7. split text in one cell into multiple cells without breaking the wo
    By Prashant in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-06-2006, 04:48 AM

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