Menu
I have a couple hundred of cells in Excel I would like to concatenate into a single string. Is there a simpler method of doing this than going through them one by one manually in order to type them into CONCATENATE(A1, A2, ....)?
CONCATENATE(A1:A255) does not work.
700
CONCATENATE Excel Range (Without any Separator)Select the entire formula and press F9 (this converts the formula into values). Remove the curly brackets from both ends. Add =CONCATENATE( to the beginning of the text and end it with a round bracket). Press Enter.
Select a cell where you want to enter the formula. Type =CONCATENATE( in that cell or in the formula bar. Press and hold Ctrl and click on each cell you want to concatenate. Release the Ctrl button, type the closing parenthesis, and press Enter.
*In a new tab, type A1 in cell A1,
*Type A2 in Cell A2
*Use fill series to complete the values in column A
*Type A1 in cell B1
Use this forumal in cell B2
=B1&","&A2
Copy the formula down.
Copy and paste 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 If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
