Full Version: Combine many cells into one cell.
UtterAccess Discussion Forums > Microsoft® Office > Microsoft Excel
kstoneman
I have a spreadsheet that has many cells with numbers that I want to combine all into one cell separated by a coma. Here is an example of what I am needing.

List
8887039514
8772342839
8887154595
8888954186
8772586202

into this 8887039514,8772342839,8887154595,8888954186
8772586202


Any help woould be greatly appreciated.
Grove
Maybe?
8887039514 (A1) <--cells
8772342839 (A2)
8887154595 (A3)
8888954186 (A4)
8772586202 (A5)

Formula in B1
=A1 & "," & A2 & "," & A3 & "," & A4 & "," & A5
Results
8887039514,8772342839,8887154595,8888954186,8772586202


HTH
erwardell
Insert a new row. Highlight all the cells in the one row, copy, click in the blank cell of the new row, special past with transpose. Then you can save the xls file as a csv file which will do as you want. If you want it as a text file then just rename the extention csv as txt after you save the file as a csv.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.