Verify data format in all rows for a column

[Closed]
Report
Posts
3
Registration date
Monday November 28, 2016
Status
Member
Last seen
November 28, 2016
-
Hello,

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?

Sheet1
USJames_2016
UKWillsmike2014

Sheet2
US-James-2016
UK-Willsmike-2014

Thanks & regards

Yuva