Re: [libreoffice-users] function concatenate

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 <pier_andreit@yahoo.it>:

> 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: users+help@global.libreoffice.org
> 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: users+help@global.libreoffice.org
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