Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Comments on Multiple string concatenation in Excel
Parent
Multiple string concatenation in Excel
In Excel I would like to concatenate several strings into one.
I could type and fill in the blanks CONCATENATE(A1, A2, ....) but it is a lot of work
This would be cool, but it does not work CONCATENATE(A1:A255)
Post
-
In a new tab, type
A1in cellA1, -
Type
A2in CellA2 -
Use fill series to complete the values in column A
-
Type
A1in 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 comment threads