Thread: Merge Two Cells and Keep all Data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default Merge Two Cells and Keep all Data
=A1&B1
--
David Biddulph

"Rob" wrote in message
...
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


Reply With QuoteReply With Quote