How to Create a Comma Separated List from an Excel Column
How to Create a Comma Separated List from an Excel Column
This process can be used to create comma-separated lists of Penn IDs from an Excel column of Penn IDs. Highlight and copy the Penn IDs.
Open a new spreadsheet and Paste > Transpose into the first cell.
Last revised 10/16/12 -- Page 1 of 3
How to Create a Comma Separated List from an Excel Column
Notice how the Penn IDs are now in a row instead of a column. Save the spreadsheet as a .csv file and close it.
Open Notepad and then open your .csv file.
Last revised 10/16/12 -- Page 2 of 3
How to Create a Comma Separated List from an Excel Column
All of the Penn IDs are now in a comma-separated list that you can cut and paste into Knowledge Link for searches of multiple people.
This is where you might be pasting your list. Make sure you use "Any" as your delimiter.
Last revised 10/16/12 -- Page 3 of 3
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- using functions formulas and calculations in web intelligence
- microsoft excel training connection
- formulas and functions libreoffice
- your excel formulas cheat sheet 15 tips for calculations
- formulas and functions openoffice
- how to create a comma separated list from an excel column
- microsoft excel 2019 formulas and functions
- excel formulas cheat sheet academic web pages
- using formulas and functions in microsoft excel
- excel 2016 formulas functions
Related searches
- how to create a federal resume
- how to create a resume
- how to create a mission statement
- how to create a professional business plan
- how to create a website
- how to create a business plan
- how to create a business
- how to create a new email account
- how to create a new email
- how to create a business email
- how to create a mission statement worksh
- how to create a excel spreadsheet