in the next openoffice could we have the CONCATENATE function that works with ranges?
for example =CONCATENATE(A1:a543) so you have all the words between A1 and A543 joined, with an option to add something between each word?
for example =CONCATENATE(A1:A543;" ") thin join the words between A1 and A543 inserting a " " space between each of them, this is already possible merging and demerging cells, but should be useful to have in tha finction too.
thanks, ciao, pier.
You can submit an enhancement request in Bugzilla.
This forum is only for helping user to user.
Thank You