Both combine text from multiple ... but remove 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 blank ...