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
 
Top