Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Splitting cells?
Is there a way to split a cell in two without adding any columns?
I am trying to figure out a way to label a series with two different names applied to the same person. Example: Right now the cells look like NE- John Doe NW-John Doe I would like them to be: NE NW with John Doe being in a split/merged cell in the middle of them so it applies to both, make sense? I don't want to add any columns because it screws up the alignment with the rest of the worksheet. I have tried merging the cells, and wrapping, but so far nothing is really giving me what I want. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Splitting cells?
You can split a cell in MS Word but not in Excel.
You would have to insert another column then merge the cells of the two column on all but the rows you want them split. Merged cells can present lots of problems, so unless you are using the worksheet as a Form, you probably want to avoid doing that. I have a page on merging and unmerging cells. Merge and Unmerge Cells http://www.mvps.org/dmcritchie/excel/merge.htm --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "mbing916" wrote in message ... Is there a way to split a cell in two without adding any columns? I am trying to figure out a way to label a series with two different names applied to the same person. Example: Right now the cells look like NE- John Doe NW-John Doe I would like them to be: NE NW with John Doe being in a split/merged cell in the middle of them so it applies to both, make sense? I don't want to add any columns because it screws up the alignment with the rest of the worksheet. I have tried merging the cells, and wrapping, but so far nothing is really giving me what I want. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Splitting cells - please help! | Excel Worksheet Functions | |||
splitting a number into two cells from one | Excel Discussion (Misc queries) | |||
splitting cells | Excel Worksheet Functions | |||
Splitting Cells | New Users to Excel | |||
Splitting Cells | Excel Discussion (Misc queries) |