How to use the CONCAT function

The CONCAT function concatenates values from multiple cells. There is, however, no delimiting character or a way to ignore empty […]