Both combine text from multiple cells into one. According to Cambridge ... Notice the spaces on each side of the word "and" in the formula. Excel doesn't add spaces here automatically, so you ...