If Statement Help (Finding a text string '76___-_____-___'")

[Vagus14]

Good afternoon everyone,

I am trying to write an if statement that will only capture a string if the string is in the following format: '76___-_____-___'" /
'S92___-_____-___'".

IIf([PART#] = '76___-_____-___'", "Yes", "No"

Is there a function I can use to get the results I want?
I sincerely appreciate the help.

 

[CJ_London]

assuming what matters is the position of the 76 and the two hyphens

 iif(left([PART#],2)="76" AND mid([PART#],6,1)="-" AND mid([PART#],12,1)="-" ,"Yes","No")

 

[Vagus14]

Hey thanks for the help! Got it!