| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
