Hello. What would be a good formula for turning this Daily Numbers Report - Summary_2014-01-26-06-02-17.xls into this Daily Numbers Report - Summary_2014-01-26.xls

I imagine it would be something with left, or mid, or something but not very good at those formulas. Thanks.