Excel: Show Two Values in a Split Cell

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Problem: My manager wants me to show two values in one cell, as shown here.

  1. One cell shows 33 & 44.

    Strategy: This formatting requires a little bit of cleverness.

    1. Type 33, then Alt+Enter, about 9 spaces, then 44, then enter.
    2. Select the cell, then Ctrl+One to access Format Cells.
    3. On the Border tab, use the diagonal border.
    4. You need to adjust the column width or the number of spaces in the cell to get it all lined up. If you add too many spaces, the row height will increase by 50%.

    Gotcha: You won't be able to do any math on numbers stored this way.

    A better method would be to store the low and high in columns. Then, use the formula =A2&CHAR(10)&REPT("œ "œ,14)&B2 in cell D2. Turn on Wrap Text. Add the diagonal border.

  2. A & B can be totaled.

For more resources for Microsoft Excel