Introducing The Law Community, the online community just for Clio customers. Sign up now.

How To Combine Text From Two Different Cells in Excel

Objective:

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

Environment:

  • Excel

Additional Information:

  • For more information click here

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)
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