kstoneman
Feb 23 2005, 07:05 PM
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
Feb 23 2005, 07:19 PM
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
Feb 23 2005, 07:22 PM
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.