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

  • Thread starter Thread starter TTM
  • Start date Start date
T

TTM

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.
 
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
 
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
 
Back
Top