+ Reply to Thread
Results 1 to 2 of 2

Deleting multiple paragraphs using macro/vba

  1. #1
    Registered User
    Join Date
    11-16-2016
    Location
    Sao Paulo, Brazil
    MS-Off Ver
    2016
    Posts
    1

    Deleting multiple paragraphs using macro/vba

    Hello there,

    My name is Pedro from Brazil (sorry in advance for all english mistakes here haha)

    I need to get information from a multi-line excel sheet and put it in a word document, turn it into text, delete the paragraphs and put commas in between them.

    I've already created a macro to delete the paragraph and add the comma at the end, but itīs getting hard as there are more lines to work with.

    I'd like to have a macro/vba that could select the number of paragraphs to be deleted, so I could reduce the work load. It would be even better if it could transform the sheet into text too

    EG:
    table:
    123
    456
    789

    text:
    123, 456, 789

    Thank you guys!

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Deleting multiple paragraphs using macro/vba

    If you paste the data into Word as unformatted text, you won't need to convert a table to text. You can then use a simple Find/Replace to change the paragraph breaks to commas. No macros required.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

+ 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. Delete all paragraphs containing a particular image using a VBA macro in MS Word
    By sshishirkumar in forum Word Programming / VBA / Macros
    Replies: 1
    Last Post: 09-30-2013, 07:06 PM
  2. Spacing multiple variable paragraphs in a merged cell
    By shotputjuggler in forum Excel General
    Replies: 4
    Last Post: 06-20-2009, 03:55 AM
  3. deleting multiple entries macro
    By noxxero in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-03-2007, 01:07 PM
  4. Replies: 0
    Last Post: 07-31-2006, 12:58 PM
  5. Replies: 0
    Last Post: 07-31-2006, 12:53 PM
  6. [SOLVED] Deleting multiple Macro buttons
    By Ant in forum Excel General
    Replies: 3
    Last Post: 06-12-2006, 09:40 PM
  7. Replies: 2
    Last Post: 06-09-2006, 05:40 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