197k views
10 votes
Explain how to add cell A1 and cell B3 in excel

User Larsch
by
6.5k points

1 Answer

6 votes

Answer:

Combine text from two or more cells into one cell

Select the cell where you want to put the combined data.

Type = and select the first cell you want to combine.

Type & and use quotation marks with a space enclosed.

Select the next cell you want to combine and press enter. for instance =A1&" "&B3.

User MikeTV
by
6.0k points