A---------------B
S6N 561 6N
S6N 573 6N
S8N 345 8N
S9S 597 9S

I would like B2 to contain only the second and third character of the part
number listed in cell A2. I think I could use wild cards but havent been
able to get it to work. Can anyone tell me what formula I would use? Any
help would be greatly appreciated. Thank you