+ Reply to Thread
Results 1 to 5 of 5

Word Macro to Remove Paragraph Breaks/Carriage Returns before copying tables to Excel

  1. #1
    Registered User
    Join Date
    11-16-2020
    Location
    Toronto
    MS-Off Ver
    14.7.1 2010
    Posts
    10

    Word Macro to Remove Paragraph Breaks/Carriage Returns before copying tables to Excel

    Hi,

    I've tried a macro that would find and replace paragraph breaks/carriage returns in between my tables in Word (These are tables I'm importing into Word are from Excel). However it does not do anything. Was wondering if anyone would be able to help me with this?

    Thank you for your time.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,717

    Re: **Word Macro to Remove/Delete Paragraph Breaks/Carriage Returns

    I don't think you need to do that to be able to import tables into Excel. You should just be able to loop through the tables. Please show all of the code you have so far. If possible also share your Word file.

    See the yellow banner at the top for how to attach a file.

    When pasting code, use code tags. There are two ways to add code tags. One is to select the code part of the text so it is highlighted, then press the "#" button in the edit controls. The other is to simply type in the tags:

    [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code]

  3. #3
    Registered User
    Join Date
    11-16-2020
    Location
    Toronto
    MS-Off Ver
    14.7.1 2010
    Posts
    10

    Re: Word Macro to Remove Paragraph Breaks/Carriage Returns before copying tables to Excel

    Hi 6StringJazzer, thank you so much for your response. I did end up finding a solution to what I was looking for but thank you so much for reaching out.

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,717

    Re: Word Macro to Remove Paragraph Breaks/Carriage Returns before copying tables to Excel

    If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

  5. #5
    Registered User
    Join Date
    11-16-2020
    Location
    Toronto
    MS-Off Ver
    14.7.1 2010
    Posts
    10

    Re: Word Macro to Remove Paragraph Breaks/Carriage Returns before copying tables to Excel

    Thank you 6StringJazzer, still learning the etiquette of this Forum

+ 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. Remove Empty Carriage Returns Only
    By plank22 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-21-2018, 11:38 AM
  2. [SOLVED] Formula to remove carriage returns
    By erikpaulsen in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-10-2015, 01:40 AM
  3. [SOLVED] Remove multiple Carriage Returns - macro to clean cell contents
    By Deskjocky in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-03-2014, 01:52 PM
  4. Replies: 1
    Last Post: 12-07-2010, 04:18 PM
  5. Can you use the Replace function to remove carriage returns?
    By iterature in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-12-2007, 08:45 AM
  6. [SOLVED] how do I remove Carriage Returns from a column in a spreadsheet?
    By Doug R in forum Excel General
    Replies: 1
    Last Post: 06-29-2005, 04:05 PM
  7. Replies: 4
    Last Post: 02-18-2005, 08:06 PM

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