Use the CONCATENATE function to put data from multiple columns together in a new one Using the concatenate formula in ...

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