Excel tutorials

Sometimes there is a need to combine the values in multiple cells into one cell. There are many ways to do this. One simple way is to use the & sign.

In column A to C we have different fruits, and in column D we have combined them using a formula.

In cell D3 enter the following forumla:

=A3&” ” &B3 & ” ” &C3

Notice that we include some spaces for readability.