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 ...

Using Excel's number format tool means you can ensure your spreadsheet both looks the part and handles your data exactly how ...