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
- company identifiers insead
- import tutorial blackbaud
- best practices for redcap database creation
- using excel for analyzing survey questionnaires
- formula method excel eastern michigan university
- quantitative analysis using excel
- the file starts with a unique id to identify the row each
- creating a project in redcap how to guide
- reshaping panel data using excel and stata
- s p capital iq s excel plug in v 8 x frequently used formulas
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