=A1&B1&C1&D1&E1&F1&G1
is about as simple as it gets.


Your first formula will not work as you have observed.
Nor will
=CONCATENATE(A1:G1)
work.
--
Regards,
Tom Ogilvy


"Harley D" wrote:

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.