JulieBunavicz
New Member
- Joined
- Oct 9, 2023
- Messages
- 10
- Office Version
- 365
- Platform
- Windows
General Question
Anyone know if it makes a difference to combine cells with TEXTJOIN or CONCAT? Below are examples I’ve found useful as a Data Analyst.
=TEXTJOIN( " ", TRUE, A2:B2, TEXT(C2, "mm/dd/yyyy") ) ---Same as below
=TEXTJOIN( " ", TRUE, TEXT(S2, "mm/dd/yyy"), TEXT(T2, "hh:mm") ) --with time and date
=D8&" "&AY8&" ("&TEXT(AT8,"mm/dd/yyyy")&")" ---Same as above
Kind regard,
Julie Bunavicz
Anyone know if it makes a difference to combine cells with TEXTJOIN or CONCAT? Below are examples I’ve found useful as a Data Analyst.
=TEXTJOIN( " ", TRUE, A2:B2, TEXT(C2, "mm/dd/yyyy") ) ---Same as below
=TEXTJOIN( " ", TRUE, TEXT(S2, "mm/dd/yyy"), TEXT(T2, "hh:mm") ) --with time and date
=D8&" "&AY8&" ("&TEXT(AT8,"mm/dd/yyyy")&")" ---Same as above
Kind regard,
Julie Bunavicz