The Excel CONCAT Function joins a range of cells or individual strings of data. This function was introduced in 2016 as a replacement/alternative to the CONCATENATE Function. Most user will use the CONCAT Function as their preferred choice.


=CONCATENATE [text1, text2], …)


  • text1 – First text value, cell reference, or range.
  • text2 – [optional] The second text value to join together.

CONCAT Function Usage Example

You can combine a range of cells as shown in the example below.

CONCAT Function

Leave a Reply

ROUND Function

The ROUND function in Excel returns a number rounded to a given number of digits. This can be used to

Read More »

ISERROR Function

The ISERROR function in Excel returns TRUE for any error type excel generates. This list of errors includes: #N/A, #VALUE!,

Read More »
Scroll to Top