Objective:
- To combine data in 2 different cells in Excel
- To understand textjoin and concat functions in Excel
Environment:
- Excel
Additional Information:
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)