Hi,

Download and install the following addin
http://www.download.com/Morefunc/300...-10423159.html and then use the
mconcat() function

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Naresh" wrote in message
...
I need to concatenate close to 200 text cells into one. How can I achive
this without need for typing each and every cell reference in the formula.

I tried the below statement but it returns me an error

=CONCATENATE('Survey Details'!J8:HZ8)

Any help will be appreciated.