Comments on OpenOffice.org Ninja: Concatenating a cell range using recursion

Hehe. Thank you, S!!!

2010-03-13T05:21:49.545-07:00

Hehe. Thank you, S!!!

All you need to do is =CONCATENATE(A1,", &...

2009-10-29T08:52:13.983-06:00
All you need to do is =CONCATENATE(A1,", ",C1) in cell C2, where A1 = your first value, and C1 is blank.
Then select cell C2, drag down the box in the lower-right corner of that cell.

Hi I'm trying to do something similar. I have ...

2008-08-25T12:07:00.000-06:00
Hi I'm trying to do something similar. I have a bunch of applications (In Categories) and which languages they support and I'm trying to figure out whether each countrie's official language fits into any of them. To do this I am using a function a bit like yours to concatenate them then do a search on that concatination (Really Ugly I know but meh)...
My Formula basically examines whether a program is in the same category as the program preceding it and then concats based on whether they are.
=IF(COUNTIF($Z$2 = $Z$1); ""; Z1 & "," & AA2)
For some reason it's not working, could really use some help.

The numbers are formatted as such because I didn't think to parse them into text and Calc seems to mess up a lot of values when you change decimal numbers to text.

I'm getting pretty frustrated and could really use some help Ninja.

jorgen near uoguelph w/ ca

Cheers!

Great solution, but still more manual than I need....

2008-07-17T05:41:00.000-06:00
Great solution, but still more manual than I need. Can't believe CONCATENATE() doesn't take a range!