Objective:

• To combine data in 2 different cells in Excel
• To understand textjoin and concat functions in Excel

Environment:

• Excel

Additional Information:

• How to use Textjoin
• How to use Concat

Answer:

There are multiple ways to join text in Excel. Textjoin is preferable where a delimiter is required. 

• Textjoin
  • Syntax =TEXTJOIN (delimiter, ignore_empty, text1, [text2], ...)
  • Delimiter - seperator between text
  • ignore_empty - true/false to ignore empty cells
• Concat
  
  • Syntax =CONCAT(text1, [text2], ...)
• "&"
  • Syntax =(text1&" "&text2)