tag:blogger.com,1999:blog-8544609315733972726.post3839192190771543043..comments2023-10-15T10:05:41.443-06:00Comments on OpenOffice.org Ninja: Concatenating a cell range using recursionAndrew Zhttp://www.blogger.com/profile/10108637160465346326noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-8544609315733972726.post-45796284930884286272013-11-01T21:29:28.672-06:002013-11-01T21:29:28.672-06:00Thank you this really helped me!Thank you this really helped me!Unknownhttps://www.blogger.com/profile/06025779720786692455noreply@blogger.comtag:blogger.com,1999:blog-8544609315733972726.post-80144537890028020642010-03-13T05:21:49.545-07:002010-03-13T05:21:49.545-07:00Hehe. Thank you, S!!!Hehe. Thank you, S!!!Cursorhttps://www.blogger.com/profile/17680390127893363421noreply@blogger.comtag:blogger.com,1999:blog-8544609315733972726.post-26727175193580472362009-10-29T08:52:13.983-06:002009-10-29T08:52:13.983-06:00All you need to do is =CONCATENATE(A1,", &quo...All you need to do is <b>=CONCATENATE(A1,", ",C1)</b> in cell <b>C2</b>, where A1 = your first value, and <b>C1</b> is blank.<br />Then select cell <b>C2</b>, drag down the box in the lower-right corner of that cell.Shttps://www.blogger.com/profile/18096446714755027580noreply@blogger.comtag:blogger.com,1999:blog-8544609315733972726.post-84478866314311891442008-08-25T12:07:00.000-06:002008-08-25T12:07:00.000-06:00Hi I'm trying to do something similar. I have ...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)...<BR/>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. <BR/>=IF(COUNTIF($Z$2 = $Z$1); ""; Z1 & "," & AA2)<BR/>For some reason it's not working, could really use some help. <BR/><BR/>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.<BR/><BR/>I'm getting pretty frustrated and could really use some help Ninja.<BR/><BR/>jorgen near uoguelph w/ ca<BR/><BR/>Cheers!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8544609315733972726.post-30087946725432454962008-07-17T05:41:00.000-06:002008-07-17T05:41:00.000-06:00Great solution, but still more manual than I need....Great solution, but still more manual than I need. Can't believe CONCATENATE() doesn't take a range!Anonymousnoreply@blogger.com