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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Concatenate Macro 5
Looking for a Date forming function 3
Concatentate A1:AZ1 separated by ~ 4
Concatenate values 4
Macro to concatenate columns 1
Concatenate many cells without zero's 9
Need macro that concatenates cells with text 7
Macro - searches for key word in a column and concatenates entire 6

Back
Top