Text Join Function - Maintain date formats for multiple columns

[Clown6489]

Hello,

I was trying to text join from columns A to M, using a column delimiter. The issue I am having is maintaining the date formula in column B,C,H and I. I have a customer number column, but dont want that impacted by the date format.

=TEXTJOIN("|",TRUE,A1:M1)

Below is my work sheet.

Company|45255|45261|Device|18|1|USD|45237|45250|2225821|End Customer|Address 1 |Address 2

 

[RoryA]

Assuming you actually have a header row, even though your posted formula refers to row 1, you could use something like:

=TEXTJOIN("|",TRUE,IF(ISNUMBER(SEARCH("date",$A$1:$M$1)),TEXT(A2:M2,"mm/dd/yyyy"),A2:M2))

 

[Clown6489]

Worked like a charm! Thank you so much!

 

[RoryA]

Glad we could help.