Merge Two Cells and Keep all Data

G

Guest

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.
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merge Cells 5
How to merge cells vertically - and keep all data 0
How to merge two cells? 3
merge two cel into ONE retaining the two values 2
merging two cells without loosing data 1
Combining Text From Cells 3
Excel Add ^ to a row of cells containing letters 3
merge cells without losing data OR format 1

Top