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.
into this 8887039514,8772342839,8887154595,8888954186
Any help woould be greatly appreciated.
Feb 23 2005, 07:19 PM
8887039514 (A1) <--cells
Formula in B1
=A1 & "," & A2 & "," & A3 & "," & A4 & "," & A5
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