The CONCAT Function
It is used to join two or more text strings into one string. This function has replaced the CONCATENATE function.
It is used to join two or more text strings into one string. This function has replaced the CONCATENATE function.
It is used to join two or more text strings into one string. This function has been replaced by the CONCAT function. Even though it is still available you should avoid using it because it may not be available in future versions of Excel.