im trying to convert a list in one column multiple cells into one cell, seperated by a comma and a space, im using this formula -
=A2&", "&A3&", "

but dont want to have to type every cell a2 a3 a4 a5 a6........etc because there are a mass number

is there a way of making it include a "range" of cells?

sorry im rubbish with excel but do try!

thanks in advance

as in the total of a list of numbers? For example,

=sum(A2:A15)

this will give the total in that cell range.

using : between the first and last cell will work as a range. equally, =sum( then drag the mouse across the cells you desire to include

HTH

look at Concatenate Finction

Enter the following in Excell

1 1
2 function in here
3
4


In cell B2 =CONCATENATE(B1,", ",A2)

copy this down to your last row that row should contain everything separated be a comma <space>

You are Concatenating the Results on line above with '<space> then with item on the left

and repeat !

Ta Da

so when completed above will look like

1 1
2 1, 2
3 1, 2, 3
4 1, 2, 3, 4

PS depending on what you wish to do with results copy the paste 'As Values'


[Edited on 7/7/17 by Agriv8]

[Edited on 7/7/17 by Agriv8]

[Edited on 7/7/17 by Agriv8]

[Edited on 7/7/17 by Agriv8]

[Edited on 7/7/17 by Agriv8]

[Edited on 7/7/17 by Agriv8]