Copying cell information

Copper Contributor

Hey there,

I'm attempting to copy the actual cell information so I can paste the data somewhere else. Does anyone know how I can do this. EG,

 

I have a list of cells which each all have country names in them.

I want to copy the countries so I can paste them somewhere else. I don't want to copy the actual cells bu rather I want to copy the information inside of the cells.

How would I do this?

 

Also does anyone know how I can also insert a comma after each country name so it appears in the following format?

Albania,Argentina...

 

Thank you,

Any input at all is much appreciated.

1 Reply
To your second question: If you have Office 365, try the TEXTJOIN function.