Transpose in Word 1

[nelson97]

I have a series of numbers in a single vertical position in MS Word. There are close to 100 items lined up. I wanted to accomplish 2 things: 1) Get them all in one row 2) Insert a quote and comma w/ each number. So that ultimately these numbers appear as such: "number1","number2","number3"

Please advice. Thanks a bunch.

 

[ThomasLafferty]

Copy paste to Excel.
Select the pasted data and Copy>Paste Special>Transpose to a new location.
Type [!]number 1[/!] and autofill across.
You can always move it back to Word if you need to...

Cheers!

Tom

Born once die twice; born twice die once.

 

[nelson97]

Thanks for the quick feedback. I transposed in Excel and copied back to Word and converted table to text with comma separation. Now, how could I accomplish putting these numbers in quotes while keeping the comma separation? These are specific numbers and not simply an autofill series of numbers. I will ultimately take the final results and put them in a report for filtering. I didn't want to have to manually adjust each number so that it ultimately looks like: "numberx","numberx","numberx"

Thanks

 

[xlhelp]

Edit,
Replace,
Find What: ^p
Replace with: ", " [double quotes, comma, space, double quotes]

Then you need to worry about the very first entry.

Me transmitte sursum, Caledoni!

 

[xlhelp]

My answer was for your intial question

Me transmitte sursum, Caledoni!