macro to add brackets to each line and add single quotes to each word in the line

gmayor · #1 02-15-2015, 07:44 AM

The comma was present in your example.

Change the section below to lose the comma (Chr(44))

Code:

            If i < UBound(vWord) Then
                strNew = strNew & Chr(32)
            End If

bracketandquotes · #2 02-15-2015, 07:55 AM

Sorry for not being clear.

What I meant is that after I ran your code there is no comma seperating the text in the results.

After the vba is run i would like there to be commas between the values like in the example where they are highlighted in red.
('AFG', 'FKFKF', 'DDJ', 'DKKFJG', 'DKDKJDJF'),

thanks for all your help and taking the time to write the code. I do appreciate it.

I have 29,300 records that need to have brackets and quotes and commas entered so the code is saving me an enormous amount of time.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How many points is line spacing 'single'?	Ugeen	Word	2	11-24-2013 03:14 PM
Changing single-quotes to double-quotes	Bobosmite	Word	5	04-15-2013 06:40 AM
From the command line, how do I run a Word macro?	jdockstader	Word	7	02-04-2013 06:09 AM
Single Line Spacing for Short Lists?	tatihulot	Word	2	04-20-2010 02:53 PM
Different alignments in a single line	George99	Word	2	01-24-2010 05:49 PM