[libreoffice-users] function concatenate

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