Both combine text from multiple cells into one ... the number 2 from cell B1, here's what we'd see: This is because we typed TRUE as the second argument in the formula to tell Excel to exclude ...