How to join all text of a column while changing the format of the data?-CodePudding

I have dates in a column that I join together and it gives me these values:

44670, 44691, 44691

I want the dates to be formatted properly like this

April- 19, May- 10, May- 10

Problem is I want to join and format any values in that column but it is also taking all the zeroes in the column and giving me an error for being too long.

So I have tried doing this but it seems slow or sometimes doesnt work:

=TEXTJOIN("
", TRUE, TEXT(IF(Sheet2!E:E>0,Sheet2!E:E,""), "mmm- dd"))

How would you go on about doing this?

CodePudding user response：

Since I have commented above and its a working solution for OP, sharing it here as an Answer as well,

• Formula used in cell C1

=TEXTJOIN(", ", TRUE, TEXT(FILTER(A:A,A:A<>""), "mmm- dd;;"))

Instead of using IF() use FILTER() function it ignores the blanks and also keeps the required formatting as needed because of TEXT() Function

Formula as per OP's Worksheet

=TEXTJOIN(", ", TRUE, TEXT(FILTER(Sheet2!E:E,Sheet2!E:E<>""), "mmm- dd;;"))