How to Combine Cells in Excel

We can combine cells in Excel i.e we can join data from two different cells in a single cell.

  • Combine Text from Multiple cells: To combine text from different cells, we use & (ampersand) operator
  • Combine Text and Add spaces to combined text: When we use & (ampersand), there is no space between the Text 1 and Text 2. To insert a space, or another Character, we can include text string in theĀ  formula.
  • Combine Cells with Text and a number: We can combine text & numbers as we have done below:

Download workbook for practice (26 downloads)

Be the first to comment

Leave a Reply

Your email address will not be published.