Function once again. If this time you get a Bogus final result, it means Excel now sees your cells as dates instead of texts I found a fresh macro that promised to automate a particularly troublesome endeavor, conserve me a huge amount of time and make me appreciably extra efficient https://www.customguide.com/excel/how-to-make-a-table-in-excel