works great and I appreciate the explanation so I can better understand how
it works the next time.

"JMay" wrote:

You want the Mid() function which has 3 parameters

=MID(A1,2,2)

A1 = the Cell you wish to examine
2 = the Character number in A1 you wish to start your extraction
2 = how many characters do you wish to pull out

HTH


"ferde" wrote:

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