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)?