UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Combine many cells into one cell.    
 
   
kstoneman
post Feb 23 2005, 07:05 PM
Post #1

UtterAccess Veteran
Posts: 435
From: Kansas
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.
Go to the top of the page
 
+
Grove
post Feb 23 2005, 07:19 PM
Post #2

UtterAccess Veteran
Posts: 348
From: NW Iowa, USA
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
Go to the top of the page
 
+
erwardell
post Feb 23 2005, 07:22 PM
Post #3

VIP Emeritus
Posts: 1,340
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.
Go to the top of the page
 
+
« Next Oldest · Microsoft Excel · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 19th May 2013 - 06:03 PM