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

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

regards
FSt1

"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

B2: =MID(A2,2,2)
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"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

Hi,

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

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

Thank you so much. I really appreciate it .

Deb

"FSt1" wrote:

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

regards
FSt1

"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

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