Not sure if there's a way to do that with functions. How about this Basic macro?
~~~~~
Option Explicit
Public Function CONCAT( ByRef rng As Variant ) As String
Dim i, k As Long
CONCAT = ""
For i = 1 To UBound( rng(), 1 )
For k = 1 To UBound( rng(), 2 )
CONCAT = CONCAT & rng( i, k )
Next k
Next i
End Function
~~~~~
Call it
- with a column type argument like “= CONCAT(a1:a10)” or
- with a row type argument like “= CONCAT(a1:j1)” or
- with an array type argument like “= CONCAT(a1:b5)”
-rl
Am 2012-10-11 um 22:49 schrieb yahoo-pier_andreit <[email protected]>:
> is there any way to have concatenate function works like sum??
> they are the same function but the first with words the second with numbers
> for example
> =SUM(a1:a10) sum all the numbers from a1 to a10
> =CONCATENATE(a1:a10) should put one after the other the words from a1 to a10
> but it doesn't works
> how can I have a such behaviour???
> of course not =CONCATENATE(a1;a2;a3;a4;a5;a6....) :-)
>
> thnx, :-) pier :-)
>
> --
> For unsubscribe instructions e-mail to: [email protected]
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be deleted
--
For unsubscribe instructions e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
