Basically what I need to do is the equivalent of typing this in once cell...
=A1&A2&A3&A4&A5&A6&A7&A8&A9&A10&A11... etc...
Is there an easy way to type this, or a formula that can do the same thing?
I've tried =A:A but this adds the total, I need to concatenate them
=A1&A2&A3&A4&A5&A6&A7&A8&A9&A10&A11... etc...
Is there an easy way to type this, or a formula that can do the same thing?
I've tried =A:A but this adds the total, I need to concatenate them