Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a list of names, each in its own cell. I need them to be in a column,
not a row. But, what I would like to do, is be able to select all the names and copy them and then, when I paste them into word or another spreadsheet have them separated by commas. So: Jeff Joe Sally becomes Jeff, Joe, Sally The excel file starts out as a CSV that was created using a text editor already in the format I want with the commas between the names... but I need to open it as an excel spreadsheet so I can do some filtering and sorting. I keep the file saved as a CSV. But, when I open the file as a CSV and put the list into a column, if I then save the file back to a CSV it is no longer in the comma separated format I need. What do i need to do? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Creating custom list with a comma in it | Excel Discussion (Misc queries) | |||
how can I list items in a column with totals? | Excel Discussion (Misc queries) | |||
Insert column entries from a master list | Excel Worksheet Functions | |||
Insert column entries from a master list | Excel Worksheet Functions | |||
Insert column entries from a master list | Excel Worksheet Functions |