I have 2 worksheets (sheet1, sheet2) which has about 50 columns each. The sheet has customer informations for the company for 2 different years. Due to some policy changes in company, the data format for the column customer ID has changed in sheet2. I need to change the sheet1 to a specific format?
How do i verify if the format in sheet1 is in the format xx-ddddd-23. Mostly the sheet1 do not have this format, and I need to have a column which returns true/false value after data format validation. Since the volume of data is in thousands, I prefer to use a formula. And I am using Excel2016 on a Mac, and hence unable to save & run a Macro?