Excel users occasionally need to combine two or more text columns into one. Here’s how to do it. (The information in this article applies to Excel 2013/2016.)

 

  • Click the cell where the combined value must go (e.g. C1)
  • Type = and click the cell containing the first value (e.g. A1)
  • Type & ” ” & and click the cell containing the second value (e.g. B1) (mind the space between the quotes)
  • Press Enter

    Categories

    Share This