merge cells

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

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.
 
=A1&","&" "&A2&","&" "&A3&","&" "&A4&","&" "&A5&","&" "&A6&","&" "&A7&","&"
"&A8&","&" "&A9&","&" "&A10

etc.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

need to display 123,000 instead of 123000 using mail merge 1
Mail Merge Formating Issues 3
Moving Text from Word to Excel (and having it set into 2 columns) 4
Sharing workbooks limitations - Merged Cells 12
VBA set thick borders around non empty cells in range 0
Excel 2002 -Merging cells contents in with a comma seperator 2
merging cells together but keeping all data from the cells 3
Allow spaces between lines of text within cell 1

Back
Top