Merge Two Cells and Keep all Data

R

Rob

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
 
D

David Biddulph

I should have added that merging cells is *not* recommended. It causes a
variety of problems, such as if you want to sort.
 
B

bj

If you do decide to merge, copy A1 and paste special values before you merge.
I agree that merging normally causes many more problems than it it is worth.
playing with borders to make it look like it is merged takes a little time
initially, but normally saves much time later if you ever have to do anything
with the sheet.
 
Top