A001 instead of P41_A001_2G

[sanlen]

Hi,

I have code numbers formatted in mess up way. ie. P41_A001_2G, P41_B23_2G,.....
i want to use if condition to return value base on the code number. However, i do not want to type the whole P41_A001_2G in my cell, and just want to use A001 or B23 instead.

=IF(C2=A3,"Yes","No")

How to trim a way P41_ and _2G and using only 3 characters in the middle as condition to return Yes or No?

Thanks,
sanlen

 

[Peter_SSs]

If this is not what you want, you may need to clarify your example a bit more.

Excel Workbook
	A	B	C	D
2	P41_A001_2G		A001	Yes
3	P41_B23_2G		X45	No
Check Part