If Formula
 

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.

If Formula
 

Maybe this

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

Mike

"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.

If Formula
 

"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?

If Formula
 

Thank you!

"Mike H" wrote:

Maybe this

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

Mike

"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.

If Formula
 

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?

If Formula
 

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

Felicia Pickett wrote:
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?