Hi ppl,

A B C D E F G
a s d f

I've tried =text(A1:G1,"GENERAL") in order to put together the value from
the prefered range but not working. So, I've to go trough using
=A1&B1&C1&D1&E1&F1&G1 to get "asdf" in cell A2.

Is there any formula that is much simple to use? Because there were more
cell to be occupied using the similar formula.

Thanks in advance.