Thread: If Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Felicia Pickett Felicia Pickett is offline
external usenet poster
 
Posts: 5
Default 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.