check file name references

[rich1e_g]

I am seeking some advice in excel. I need excel to check file name references as the right characters. The issue is the string is not always the same no. of characters as can be extended if Sub-Contractor Originator/Internal No. or Sub-Location or Level is added see Table 1 green section. on the attached document

A separate issue is that users will occasionally use the wrong separator i.e _ or – which I need to check is correct an in line with Table. 1

Table two is an example of the variation of the file name references with its correct separators and how long the string.

Can someone please assist with providing some guidance of what is the best way of crosschecking/validating the file name reference is correct?

[AliGW]

The Excel workbook would be far more helpful than a Word document. Please attach it for us (desensitised). Thanks.

[rich1e_g]

I am not even sure which formula to start with. I have attached some examples of what I want to achieve in excel

[rich1e_g]

I was thinking of using the LEN Formuala with LEFT, but not sure if that will work

[JeteMc]

This may be of some help, although it leaves the issue of "Reason" untouched.
To identify the correct and incorrect statuses use: =IF(ISNUMBER(MATCH(D2,A$2:A7,0)),"Correct","Incorrect")
Let us know if you have any questions.