| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
merge cells
I need to take a column of numbers and have them displayed either in a cell
or word document with a comma and space between each number. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
merge cells
=A1&","&" "&A2&","&" "&A3&","&" "&A4&","&" "&A5&","&" "&A6&","&" "&A7&","&"
"&A8&","&" "&A9&","&" "&A10 etc. "Ken" wrote in message ... I need to take a column of numbers and have them displayed either in a cell or word document with a comma and space between each number. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
merge cells
I would use a help column. Say A1 thru A10 has:
97 316 373 258 368 116 289 390 42 63 in B1, enter: =A1 In B2, enter: =B1 & ", " & A2 and copy down. In B10 we see: 97, 316, 373, 258, 368, 116, 289, 390, 42, 63 -- Gary''s Student - gsnu200807 "Ken" wrote: I need to take a column of numbers and have them displayed either in a cell or word document with a comma and space between each number. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
merge cells
You don't need &","&" "&
&", "& would do. -- David Biddulph "Gaurav" wrote in message ... =A1&","&" "&A2&","&" "&A3&","&" "&A4&","&" "&A5&","&" "&A6&","&" "&A7&","&" "&A8&","&" "&A9&","&" "&A10 etc. "Ken" wrote in message ... I need to take a column of numbers and have them displayed either in a cell or word document with a comma and space between each number. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I merge cells into one then delete the original cells? | Excel Worksheet Functions | |||
| Merge Cells | Excel Discussion (Misc queries) | |||
| Why can't I merge 2 cells into one? | Excel Discussion (Misc queries) | |||
| How do I merge cells in Excel, like just 2 cells to make one big . | Excel Discussion (Misc queries) | |||
| Merge Cells | Excel Discussion (Misc queries) | |||
Linear Mode
