You can only combine text from a array of cells (A1:A10), not from individual identified cells or text like in concatenate (e.g., concatenate(A1,B10,C20, “A”)). To use the same example as above: =STRJOIN(A1:E1,",") will give you 5,4,5 Moreover, it lets you define the delimiter as well as strings that go before and after each non-blank entry in the range. It combines all the text from cells, but unlike the standard concatenate function, it ignores empty cells. For example, using the concatenate function: =concatenate( A1, " ", B1," ",C1," ", D1, " ", E1, " ") will give you 5,4,5.Ī quick search on the Internet gave me this custom made function STRJOIN, which works perfect. You can get C1 by combining A1 and B1 using one of the two options below: =CONCATENATE(A1, " ", B1) =A1&," ",&B1īut what if you have the following table:Īnd you want to combine A1:E1, separating each number by a comma, but ignoring empty cells? Unless I am missing something, the two options above won’t work. In OpenOffice / LibreOffice Calc, you would normally use CONCATENATE to combine strings from different cells, like in the example below:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |