I have 100 cells that display either a number, or nothing in them. If there is a number =1, I would like it to display on one page, my master page. The second page is where I copy & paste all of my information, and the display page, or pretty part is the first page. I have tried many thing I have seen, the + method, the &""& method. None of these work. Is it possible to display the content all in one cell?