No I just want the letter that shows up in the 6th spot.

"JoeU2004" wrote:

"Felicia Pickett" wrote:
My cell contains the text: UWWHHM9908BEN
In a blank cell how do I ask Excel to pull only the M in my blank cell.
I want to say "if character 6 is M, then put M in my cell.

Otherwise what?!

=if(mid(A1,6,1)="M","M","")

That leaves a null string (which display as blank) if the 6th character is
not "M".

Caveat: This matches "m" as well as "M". Do you care?