No functions of which I'm aware. A short macro would do it, tho

Sub ConcatSelection()
Dim rng As Range
Dim strConcat As String

For Each rng In Selection
strConcat = strConcat & rng.Text
Next
Range("B1") = strConcat
End Sub

For information on installing the code see
Getting Started with Macros and User Defined Functions

http://www.mvps.org/dmcritchie/excel/getstarted.htm



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