How do I add the contents of two cells, containing text.
 

I have two cells containing two words.
A1 and B1, in the cells I have two words, e.g. 'This' and 'Cell'.
is there a way of adding the contents of the cells with a formula, so that I
get the result in another cell, say, C1 - so it reads 'This Cell'?

I am using Excel 2003 (SP1) and XP Pro with SP2.

Thanks.

How do I add the contents of two cells, containing text.
 

Try

=A1&" "&B1

In C1

Mike

"TTM" wrote:

I have two cells containing two words.
A1 and B1, in the cells I have two words, e.g. 'This' and 'Cell'.
is there a way of adding the contents of the cells with a formula, so that I
get the result in another cell, say, C1 - so it reads 'This Cell'?

I am using Excel 2003 (SP1) and XP Pro with SP2.

Thanks.

How do I add the contents of two cells, containing text.
 

And just to add to that, you could do it like this.

="'"&A1&" "&B1&"'?"
Which would return the result as you posted it i.e. 'This Cell'?

Obviously that is not what you meant, I just thought I'd add
it to show some of the possibilities.

HTH
Martin

"TTM" wrote in message
...
I have two cells containing two words.
A1 and B1, in the cells I have two words, e.g. 'This' and 'Cell'.
is there a way of adding the contents of the cells with a formula, so that
I
get the result in another cell, say, C1 - so it reads 'This Cell'?

I am using Excel 2003 (SP1) and XP Pro with SP2.

Thanks.

How do I add the contents of two cells, containing text.
 

Or you could also use the CONCATENATE function. But dont forget to add any
spaces where cells may join

=CONCATENATE(A1," ",B1)

The Speech Marks denotes text characters so you end up with This followed by
a space character followed by the word Cell

Saruman

"TTM" wrote in message
...
I have two cells containing two words.
A1 and B1, in the cells I have two words, e.g. 'This' and 'Cell'.
is there a way of adding the contents of the cells with a formula, so that
I
get the result in another cell, say, C1 - so it reads 'This Cell'?

I am using Excel 2003 (SP1) and XP Pro with SP2.

Thanks.