wild card?? formula question please

[ferde]

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

 

[FSt1]

hi,
try
=mid(A2,2,2)

regards
FSt1

 

[Barb Reinhardt]

B2: =MID(A2,2,2)

 

[Carim]

Hi,

In cell B2, just type in :
=MID(A2,2,2)
HTH

 

[JMay]

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]

Thank you so much. I really appreciate it .

Deb

hi,
try
=mid(A2,2,2)

regards
FSt1

 

[ferde]

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