Merge series of multiple ranges and/or text strings.
The Excel CONCAT function display text by combining multiple ranges, array and/or strings. For example, to connect two separate texts, Mike & Tyson, the formula can be =CONCAT(“Mike “, “Tyson”) returns “Mike Tyson”, note space after “Mike ”.
=CONCAT(text1, [text2], …)
text – One or more text string to join.
- The CONCAT function can also merge data between table, array not just cells.
- It doesn’t provide the delimiter or Ignore Empty arguments.
- In some case, the ampersand character (&) can also be an effortless alternative to the CONCAT function, like =”Indian “& “Ocean” returns “Indian Ocean”.
- The user can input a maximum of 253 text arguments in this formula. Moreover, the merged text should not exceed 32767 characters (cell limit) otherwise it will return the #VALUE! error.
- Introduced in Excel 2016 (Office 365), the CONCAT function is a versatile version of CONCATENATE function.