Easily concatenate several cells?

Giganews Newsgroups
Subject: Easily concatenate several cells?
Posted by:  Kenneth Lam (NOSPAM-kennethli…@yahoo.com.hk)
Date: Sat, 01 May 2004

Other than using:
=concatenate(A1,A2,A3,A4,A5)
or
=A1&A1&A3&A4&A5
or
VBA code

is there any way to do concatenate like
=XXXX(A1:A5) ?

I have tried using concatenate in array but doesn't work.
Thanks

Replies