| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merge the contents of multiple cells into one cell
I've merged contents of multiple cells into one and now that I don't need A2
and B2 Cells, the information from the merge disappears if i delete those two cells. How do I stop this? Example below: A2: 869000471 B2: 02810 C2: 86900047102810 The formula that I used was =A2&""&B2 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Merge the contents of multiple cells into one cell
Copy C2 and paste/special/value back onto C2
-- Gary''s Student - gsnu200826 "Penny" wrote: I've merged contents of multiple cells into one and now that I don't need A2 and B2 Cells, the information from the merge disappears if i delete those two cells. How do I stop this? Example below: A2: 869000471 B2: 02810 C2: 86900047102810 The formula that I used was =A2&""&B2 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Merge the contents of multiple cells into one cell
You sure you kept the leading 0 that appeared in B2?
If those values are really numbers, you may want: =text(a2,"000000000")&text(b2,"00000") (no need for &""&) After you've created the formula, you can select those formula cells (all of column C) and do: select column C Edit|copy edit|paste special|values And delete columns A and B Penny wrote: I've merged contents of multiple cells into one and now that I don't need A2 and B2 Cells, the information from the merge disappears if i delete those two cells. How do I stop this? Example below: A2: 869000471 B2: 02810 C2: 86900047102810 The formula that I used was =A2&""&B2 -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Merge the contents of multiple cells into one cell
Thank you both for your help.. !!!
"Dave Peterson" wrote: You sure you kept the leading 0 that appeared in B2? If those values are really numbers, you may want: =text(a2,"000000000")&text(b2,"00000") (no need for &""&) After you've created the formula, you can select those formula cells (all of column C) and do: select column C Edit|copy edit|paste special|values And delete columns A and B Penny wrote: I've merged contents of multiple cells into one and now that I don't need A2 and B2 Cells, the information from the merge disappears if i delete those two cells. How do I stop this? Example below: A2: 869000471 B2: 02810 C2: 86900047102810 The formula that I used was =A2&""&B2 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| separate contents of one cell into multiple cells | Excel Worksheet Functions | |||
| Excel 2000 - Split Contents of Cell Across Multiple Cells | Excel Discussion (Misc queries) | |||
| copy contents of multiple cells into a new cell - Help Needed Please | Excel Programming | |||
| How do I merge 2 cells to 1 when contents are numbers | Excel Discussion (Misc queries) | |||
| How do I combine the contents of multiple cells in one cell? | Excel Worksheet Functions | |||
Hybrid Mode
