Thread: How do I add the contents of two cells, containing text.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default 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.

Reply With QuoteReply With Quote