Is there an easier way to join 100 cells worth of text without putting:
=A2&A3&A4&A5&...&A100
Ideally, I'd love to be able to put in
=CONCATENATE(A2:A100)
but this doesn't seem to work. And writing out
=CONCATENATE(A2,A3,A4...)
is longer than just doing it the first way. Suggestions?
=A2&A3&A4&A5&...&A100
Ideally, I'd love to be able to put in
=CONCATENATE(A2:A100)
but this doesn't seem to work. And writing out
=CONCATENATE(A2,A3,A4...)
is longer than just doing it the first way. Suggestions?