The CONCAT function is like CONCATENATE except that it lets you use a range of cells as an argument. The CONCAT and TEXTJOIN functions are new functions that requires an Office 365 subscription (they work in Excel Online). NOTE The spaces before and after the & operator are not required - I've included the spaces only to help make the formula more readable.