If Formula

[Felicia Pickett]

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.

 

[Mike H]

Maybe this

=IF(MID(A5,6,1)="m","M","")

Mike

 

[JoeU2004]

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?

 

[Felicia Pickett]

Thank you!

Maybe this

=IF(MID(A5,6,1)="m","M","")

Mike

 

[Felicia Pickett]

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

 

[David Biddulph]

In that case, use
=MID(A1,6,1)
--
David Biddulph

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