Column to CSV...

P

PegL

When you paste the column into the new worksheet, do a
Paste Special and select Transpose. This will put the
entries into columns. You can then save it as a csv.
-----Original Message-----
I have a spreadsheet that has a many columns of customer
Click to expand...
data. I would like to be able to select one of the
columns and then somehow turn it into a text file of
CSVs. I would like the text file to appear as:
item1, item2, item3, etc, etc.

If I copy a column, create a new worksheet, paste the
Click to expand...
items into a new worksheet and then save the workseet as
a CSV I get the following when opening the CSV in a text
editor:
 
Top