If Formula

  • Thread starter Thread starter Felicia Pickett
  • Start date Start date
F

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.
 
Felicia Pickett said:
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.
Click to expand...

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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If formula Date not Blank 2
Excel Import Comments 3
IF date not blank 5
if function and date 2
Conditional Formating Formula? 5
formula issue between cells 4
Finding Text within an Array 2
Formula 1

Back
Top