View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Merge Two Cells and Keep all Data

hi,
try this in C1.....
=CONCATENATE(A1,B1)

Regard
FSt1

"Rob" wrote:

Hello,

In cell A1 I have the letters CTP. In cell B1 I have the number 1234.

I want to merge the two cells together and have one cell that reads CTP1234.

Is this possible?

Thanks!

Rob