| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I merge two cells without deleting data from the cell? | Excel Discussion (Misc queries) | |||
| how do i merge data from specific cells to different workbooks? | Excel Worksheet Functions | |||
| merge cells that contain the same data | Excel Discussion (Misc queries) | |||
| Problem with data from cells in merge fields | Excel Worksheet Functions | |||
| Merge data from different cells | Excel Discussion (Misc queries) | |||
Linear Mode
