On Tue, 14 Mar 2006 12:38:27 -0800, Wildaz
wrote:

Thank you. I was looking in the other forums and found a function to
download that does this. It is MCONCAT.

"Wildaz" wrote:

Is there a function similar to concatenate that doesn't require each
individual cell to be referenced?

I have a database that has information in cells A1 through A1000. I
currently use conatenate(A1, .....,A1000). Is there a fundtion that will
return the same information - FUNCTION(A1:A1000)?


To use MCONCAT, you'll need to download and install Longre's free morefunc.xll
add-in from http://xcell05.free.fr/
--ron