View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
John C[_2_] John C[_2_] is offline
external usenet poster
 
Posts: 1,358
Default Combine Text Cells

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!