CONCATENATE Function

The name CONCATENATE means to combine or to join. The Excel CONCATENATE function combines or joins text located in different cells to one cell. Microsoft introduced the CONCAT function to replace CONCATENATE in 2016. However, CONCATENATE will remain active in later versions for compatibility issues. The best practice is to use the CONCAT function since