News

Manually combining data from two ... with the TEXTJOIN function. =TEXTJOIN(" and ",TRUE,A1:C1) Notice the spaces on each side of the word "and" in the formula. Excel doesn't add spaces here ...