Question Locked

Excel adding information from one cell to another cell

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have three different cells with words in them and i need to add them all into one cell. Is there a formula for this?

example

cell a1 says happy
a2 sad
a3 mad

i want my end product to be

cell a1 saying happy sad mad

thanks.

4 replies

by aleksic80

You can use a formula with the ampersand (&) operator to combine text from multiple cells into one cell.

Select the cell in which you want to combine the contents of other cells.
To start the formula, type =(
Select the first cell that contains the text that you want to combine, type &" "& (with a space between the quotation marks), and then select the next cell that contains the text that you want to combine.
To combine the contents of more than two cells, continue selecting cells, making sure to type &" "& between selections. If you don't want to add a space between combined text, type & instead of &" "&. To insert a comma, type &", "& (with a comma followed by a space between the quotation marks).

To finalize the formula, type )
To see the results of the formula, press ENTER.

by sundarcin

Use & operator

in cell a4 type =a1&a2&a3

you will get the result

:)

This discussion is closed to new replies.