View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mbing916 mbing916 is offline
external usenet poster
 
Posts: 9
Default 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.