Combine two or more cells in Excel and Google Sheets
=CONCATENATE(A2,A3)
=CONCATENATE(A2,A3)
=A2&"-"&A3
=CONCATENATE(A2,"-",A3)
=TEXTJOIN("-",TRUE,A2:A3)
=TRANSPOSE(TEXTJOIN("-",1,A2:A5))
💡 Download the Excel file used in this exercise here.
=A2&"-"&A3
=CONCATENATE(A2,"-",A3)
=TEXTJOIN("-",TRUE,A2:A3)
=TRANSPOSE(TEXTJOIN("-",1,A2:A5))
=ARRAYFORMULA(CONCATENATE(A2:A3&" "))
💡 View the Google Sheets file used in this exercise here.