How to Combine text from two or more cells into one cell in Excel

 How to Combine text from two or more cells into one cell in Excel

01. CONCAT function

The CONCAT function can combine text from multiple ranges of cells and/or strings, but it doesn't provide delimiter or Ignore Empty arguments. CONCAT replaces the CONCATENATE function. However, the CONCATENATE function will remain available for compatibility with earlier versions of Excel.

 Formula   --  =CONCAT(B2," ", C2)

Result --  Joins three things: the string in cell B2, a space character, and the value in cell C2.

If you update this formula as =CONCAT(B2," //", C2) 

The final result will be updated in cell B2, a // character, and the value in cell C2.

Example 1

Formula    =CONCAT(F2,"-",E2)

Final Result   ---  

 If you want to learn details, please watch this video tutorial.