Forum Discussion

Josh_Waldner's avatar
Josh_Waldner
Brass Contributor
Nov 25, 2021
Solved

array to text

is there a way to format an array as one string in a cell? right now i am using this formula: =TEXTJOIN(", ",TRUE,E64:E76) and get this result: 21, 23, 24, 25, 26, 27, 28, 21, 0,  ,  ,  ,  , 0. bu...
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Nov 25, 2021

    Josh_Waldner 

    So, you need to exclude cells with zero, blank cells and cells with non-breaking space. That could be like

    =TEXTJOIN(", ", 1, IF( ( K8:K22=0 ) + ( K8:K22=UNICHAR(160) ), "", K8:K22 ) )
Juliano-Petrukio's avatar
Juliano-Petrukio
Bronze Contributor
Nov 25, 2021

 

Sorry for jumping on this Mr SergeiBaklan  but I found it quite interesting and I would like to propose some approach as well.

 

Josh_Waldner Considering your data range  E64:E76.

 

 

 

=TEXTJOIN(",",TRUE,FILTER(E64:E76,ISNUMBER(E64:E76)*(E64:E76>0)))

 

 

 

Resources