Array formula text join with column header

57 Views Asked by At

How to fix this formula, so I can turn the column of dates into text?

=ArrayFormula(UNIQUE((IF(row($A:$A)=1,"DATE LOOKUP",(TEXTJOIN("",TRUE,A1:A))))))

This formula is combining all in one cell - I need each cell to convert in the column not all in one.

enter image description here

=ArrayFormula(UNIQUE((IF(row($A:$A)=1,"DATE LOOKUP",(TEXTJOIN("",TRUE,A1:A)))))) 

I need to know how to fix this formula so that the results look like this

enter image description here

2

There are 2 best solutions below

4
Codedabbler On BEST ANSWER

Try this:

=ARRAYFORMULA({"Date Lookup";IF(A2:A<>"",TEXT(A2:A,"d-mmm-yyyy"),)})

Screenshot

3
Martín On

You can use TO_TEXT:

=ARRAYFORMULA(TO_TEXT(A2:A))