J JBM Aug 7, 2004 #1 Is there a single button command for "concatenate"? I know about the "sum" and then concatenate. Thanks
Is there a single button command for "concatenate"? I know about the "sum" and then concatenate. Thanks
D Dave Peterson Aug 7, 2004 #2 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
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
