View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default How to connect characters together in different cells?

In C1 enter =A1&B1


Gord Dibben MS Excel MVP

On Thu, 28 Sep 2006 18:52:01 -0700, Eric wrote:

In cell A1 = ABC;
In cell B1 = 123;
I would like to join both strings together, then
In cell C1 = ABC123

Does anyone know how to do it in excel?
Thank anyone for suggestion
Eric