NO, you have to do it that way as TEXT cannot work on an array, nor can
CONCATENATE.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Harley D" <[email protected] wrote in message
...
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.