title: Excel: Add number to upper right corner of box of merged cells
body: <p>I have an excel form which displays a six generation family pedigree chart.  Each box for a person's data is merged together from 3 columns and 7 rows.  4 lines of text fit into each box, the 1st line is name, the 2nd birth date and place, the 3rd marriage date and place and the 4th death date and place.</p>
  
  <p>The rightmost two columns are the triple great grandparents of the root person and sometimes a 2nd chart is needed to show their ancestors.  The 2nd chart tile is Chart mm-nn where mm is the chart number where the person appears as a GGG grandparent and nn is their number in that chart.</p>
  
  <p>How can I put a number in the upper right corner of these boxes in my chart?</p>
  
  <p>I thought of appending the number to the person's name and flush it right.  If possible, it must be with some exotic format string.  But each box has 4 text lines and the flush right formatting needs only apply to the 1st.</p>
  
  <p>Perhaps make the numbers as little graphics and overlay them?  Chop up the base cells even smaller and merge them into 4 separate lines with the 1st line shorter than the others with a small number box at the end of it?</p>
  
  <p>Ideas?</p>
  
  <p>Jim</p>