Concatenate Range 2.0 screenshot 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. Download Concatenate Range 2.0