This article may be out of date!
Visit the New Knowledge Center

How To Combine Text From Two Different Cells in Excel


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


  • Excel

Additional Information:


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)
Was this article helpful?
This information is confusing or wrong
This isn't the information that I was looking for
I don't like this functionality