Change column formatting

[Accure]

Thanks in advance everyone! I did search, but did not know the proper terms to pull up the correct info.

What i need to do is change Column A to this formatting, "name 1", "name 2", "name 3"

Column looks like this currently,

name 1
name 2
name 3

I need it to look like this,

"name 1", "name 2", "name 3"

[Palmetto]

Are you saying you want to transpose the column into a row of values or are you wanting to create a comma delimited string of names?

If it is simply transposing from column to row list, then select all values in the column, right-click and choose copy, then select an empty row, right-click and choose Paste Special > Transpose.

It you want a comma delimited string, then it will require VBA coding.

[Accure]

Are you saying you want to transpose the column into a row of values or are you wanting to create a comma delimited string of names?

If it is simply transposing from column to row list, then select all values in the column, right-click and choose copy, then select an empty row, right-click and choose Paste Special > Transpose.

It you want a comma delimited string, then it will require VBA coding.

I need a comma delimited string of names.

is the VBA coding a difficult concept or is it something I can just plug in?

[Accure]

And to clarify i need this to paste into word

it does not need to go back into excel

[MarMo]

Hi Accure ,
You are talking about transposing data.
Manually you can do this with the Copy / PastSpecial menu.
Copy the cells needed "Name1" "Name2" etc
Rightclick on Cell A1 and select pastespecial.
Make sure you select "Transpose" at the bottom of the form and click OK.
Now the data will appear in columns.

[martindwilson]

do it all in word .copy the col of data paste special as unformatted text into word,
in word use find /replace
find what: ^p
replace with: ,
replace all

[Accure]

Thanks for the responces, let me test these two suggestion and I will report back

[Accure]

Hi Accure ,
You are talking about transposing data.
Manually you can do this with the Copy / PastSpecial menu.
Copy the cells needed "Name1" "Name2" etc
Rightclick on Cell A1 and select pastespecial.
Make sure you select "Transpose" at the bottom of the form and click OK.
Now the data will appear in columns.

Dont think this is what I am looking to do.

[Accure]

do it all in word .copy the col of data paste special as unformatted text into word,
in word use find /replace
find what: ^p
replace with: ,
replace all

Martin,

Thanks you this does work, but i need quotes around the names. right now i have name 1, name 2, name 3,

i need

"name 1", "name 2", "name 3" etc

[Accure]

All i had to do was have it change to " , "


Thanks Martin and everyone else!