Pulling Text from 2 Cells and Joining in a Third Cell

[Craig]

Is it possible to have a third cell pull the text out of
two other cells and then join them in that third cell?

For instance, if A1 had "green" and B1 had "apples"...is
there a fomula for C1 to have "green apples"??

Thanks,
Craig

 

[Dave R.]

yes, you can join the strings by typing the cell addresses with an &
inbetween them, like

=A1&B1

will give you "greenapples"
you can use the & sign to add text such as a space like
=A1&" "&B1

for "green apples"

 

[RickBurda]

You can also use the =CONCATENATE() function, it does the same thing as
the prior repl, but allows you to use the GUI (Graphic User Interface)
that Excel uses with all its functions. This is handy esp if you have
more than 2 cells to combine, and if it has numbers or text. When the
GUI come up, select the small box to the right of the first line, the
GUI disapears so you can select the cell you want, then select the
small box when you are done, and the GUI appears for your next line.
You can them put your space," " in it, then go to the next line. At the
bottom, you can see your result before closing (hitting the Ok button)