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

CUMIPMT Function

How much interested have I paid? The CUMIPMT Function in Excel is a financial function designed to calculate and return

Read More »

What is a Macro?

Macro is just the name given to the codes written in VBA. So our codes, henceforth, will be referred to

Read More »
Scroll to Top