Multiple string concatenation in Excel
2 answers
+2
−0

In a new tab, type
A1
in cellA1
, 
Type
A2
in CellA2

Use fill series to complete the values in column A

Type
A1
in cellB1

Use this formula in cell
B2
=B1&","&A2

Copy the formula down.

Copy and Paste Special, Values to harvest the string of values you created.
A1 A1
A2 A1,A2
A3 A1,A2,A3
A4 A1,A2,A3,A4
A5 A1,A2,A3,A4,A5
A6 A1,A2,A3,A4,A5,A6
A7 A1,A2,A3,A4,A5,A6,A7
A8 A1,A2,A3,A4,A5,A6,A7,A8
A9 A1,A2,A3,A4,A5,A6,A7,A8,A9
A10 A1,A2,A3,A4,A5,A6,A7,A8,A9,A10
0 comments