concatenate button

J

JBM

Is there a single button command for "concatenate"? I
know about the "sum" and then concatenate.

Thanks
 
D

Dave Peterson

Not that I know of, but if you're using the =concatenate() worksheet function,
you may want to start using the ampersand (&).

=concatenate(a1,b3,c3,d9)
can be written
=a1&b3&c3&d9
 

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

Generating Functions with "Concatenate" 2
Constructing Range Name calls with Concatenate 4
concatenate in array formula? 1
Concatenate with hyphens answer 3
CONCATENATE & LOOKUP Functions 0
Concatenate 5
Concatenate 2
Limitations on Sumif Calculation 3

Top