chris_smith
|
| posted on 7/7/17 at 01:07 PM |
|
|
excel gurus required
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
The secret of success is to know something nobody else knows."
|
|
|
|
|
WallerZero
|
| posted on 7/7/17 at 01:48 PM |
|
|
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
http://zachsgbszero.blogspot.co.uk/
|
|
|
Agriv8
|
| posted on 7/7/17 at 02:10 PM |
|
|
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]
Taller than your average Guy !
Management is like a tree of monkeys. - Those at the top look down and see a tree full of smiling faces. BUT Those at the bottom look up and see a
tree full of a*seholes .............
|
|
|
