Note 1 If N cells at the top of the A row are blank and you just let C2 = A2, the first N rows on C will show 0, and a single 0 will be prepended to the concatenation result. Wherever you need the result of the concatenation, reference C24. If you may have blanks, as I do, there needs to be a conditional in C2 to treat the first cell as blank text, instead of as zero Note 1:Ĭopy C3, then highlight C4:C24 and paste the formula to autofill those cells. G1 shows the concatenated result in an easy-to-see spot near the top of the document.Ĭolumns B and D, and cell G2, utilize the same method to show the "finished" data. Row 2 is the first row, and row 24 is the final row. Column C is used to perform the concatenation. When pressing ALT + ENTER in a field of an OpenOffice table, nothing happens. Unfortunately, this seems not to work this way using the spreadsheet software Calc from the Open Office or LibreOffice Suite. The example removes the 7 empty rows per letter and manually inputs which letters are finished/unfinished for convenience.Ĭolumn A is the "unfinished" column to be concatenated. In Microsoft Excel, it is possible to insert multiline texts in cells using the key combination ALT + ENTER. I wanted to just mash all the finished letters together in one cell to be easy to view, and the same with the unfinished letters. The letters only appear on every 8th row, so I can't view them all at the same time. In my case, I had one column with letters corresponding to finished worksets, and one column with letters corresponding to unfinished worksets. As the general question (how to concatenate a range of cells) is useful to many people, I think my answer should still be useful even though I haven't done that. His answer explicitly addresses separating the items with delimiters, as well as the opening and closing quotations, as the question above uses. This is essentially a duplicate of pnuts' answer, but with images to hopefully help. CONCATENATE doesn't accept cell ranges, and there isn't a TEXTJOIN function like LibreOffice. As of version 4.1.7 of Apache OpenOffice Calc, there still isn't a simple solution to this problem.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |