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)