Merge Two Cells and Keep all Data
 

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

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

Merge Two Cells and Keep all Data
 

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

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
=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

Merge Two Cells and Keep all Data
 

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.

"David Biddulph" wrote:

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

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
=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

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