how to combine excel cells

Question 1

To combine cells in Excel, you can use the CONCATENATE function or the "&" operator. For example, if you want to combine the contents of cells A1 and B1, you can use either:

Question 2

`=CONCATENATE(A1, B1)`

or

`=A1&B1`

Both formulas will give you the combined text of cells A1 and B1.

rahma · Answer 1 · 2024-03-09T11:21:42+0000

`=CONCATENATE(A1, B1)`

or

`=A1&B1`

Both formulas will give you the combined text of cells A1 and B1.

how to combine excel cells

Please log in or register to answer this question.

1 Answer

Please log in or register to add a comment.