Hello,
I have a range, for example a1:a10. Is there a shorthand for
concatenating the strings into one string, without typing each and
every cell in the concatenate formula. I want to use something like:
Concatenate("A1":"A10").

Any suggestions?