| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Merge then delete cells
I need to merge three cells (which I have figured out how to do) and then I
need to delete the 3 cells that I used to merge. Please Help! -- Jodi Funke |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Merge then delete cells
Please don't merge cells! The archives of this group have countless reports
of problems associated with merged cells. -- David Biddulph "Jodi Funke" wrote in message ... I need to merge three cells (which I have figured out how to do) and then I need to delete the 3 cells that I used to merge. Please Help! -- Jodi Funke |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Merge then delete cells
Merge or Combine?
If you combined by =A1&B1&C1 or =CONCATENATE(A1,B1,C1) entered in D1 copy D1 and paste specialvaluesokesc. Now delete Contents of A1:C1 Gord Dibben MS Excel MVP On Thu, 5 Jun 2008 13:46:01 -0700, Jodi Funke wrote: I need to merge three cells (which I have figured out how to do) and then I need to delete the 3 cells that I used to merge. Please Help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I merge cells into one then delete the original cells? | Excel Worksheet Functions | |||
| Match, Copy, Merge, Delete and Repeat... MVP's this one's for you. | Excel Discussion (Misc queries) | |||
| delete multiple addresses in excel before mail merge | Excel Discussion (Misc queries) | |||
| How do I delete the line between 2 cells and merge them into one . | Excel Discussion (Misc queries) | |||
| How to delete duplicate records when I merge two lists (deleting . | Excel Worksheet Functions | |||
Hybrid Mode
