How to use function Concatenate

  • Thread starter Thread starter Peter Wallin
  • Start date Start date
P

Peter Wallin

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?
 
Back
Top