Concatenate Range - Concatenates ranges of cells in Excel, with optional formatting and delimiters. This CONCATENATERANGE formula is a better alternative to TEXTJOIN because it works in all Excel versions, and can use cell formats to format the result. Once installed, you can join cell ranges by using the CONCATENATERANGE formula.