How to use function Concatenate
 

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?

How to use function Concatenate
 

Hi
you may try the free Add-in Morefunc.xll
(http://longre.free.fr/english) and use the function MConcat

--
Regards
Frank Kabel
Frankfurt, Germany

Peter Wallin wrote:
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?