Combine Text Cells

Is there a formula to combine the text in multiple cells into one cell? I.E.
if Cell A1 says RNA and Cell B1 says Te4 and Cell C1 says Late, is there a
way to make Cell D1 combine them and be "RNA Te4 Late"?

Thanks!

johnc
Thu Jul 24 08:37:06 CDT 2008

You can use Concatenate, or just a regular formula:
=CONCATENATE(A1," ",B1," ",C1)
=A1&" "&B1&" "&C1
--
John C


"lightbulb" wrote:

> Is there a formula to combine the text in multiple cells into one cell? I.E.
> if Cell A1 says RNA and Cell B1 says Te4 and Cell C1 says Late, is there a
> way to make Cell D1 combine them and be "RNA Te4 Late"?
>
> Thanks!
>

tipsoftheweek
Thu Jul 24 08:38:37 CDT 2008

=A1&" "&B1&" "&C1

The " " just adds a space in between the words.

You could also use =Concatenate(A1,B1,C1) if you don't need the spaces
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"lightbulb" wrote:

> Is there a formula to combine the text in multiple cells into one cell? I.E.
> if Cell A1 says RNA and Cell B1 says Te4 and Cell C1 says Late, is there a
> way to make Cell D1 combine them and be "RNA Te4 Late"?
>
> Thanks!
>

David
Thu Jul 24 08:40:29 CDT 2008

=A1&" "&B1&" "&C1
or
=CONCATENATE(A1," ",B1," ",C1)
--
David Biddulph

"lightbulb" <lightbulb@discussions.microsoft.com> wrote in message
news:57801AA0-D40D-4CEE-9D17-0A6DF190A465@microsoft.com...
> Is there a formula to combine the text in multiple cells into one cell?
> I.E.
> if Cell A1 says RNA and Cell B1 says Te4 and Cell C1 says Late, is there a
> way to make Cell D1 combine them and be "RNA Te4 Late"?
>
> Thanks!
>