Using MID then IF to the result, is this possible?

[Related1]

Hi!

Not a seasoned user here so please be gentle

How would I combine two formulas when one is dependent on the other?

For example I am using the MID formula first to pull out letters I need. There are several answers that can be returned, but if the answer is BE, I would like it changed to BEX.

I am using =MID(A11,5,2) (I suppose I could change the 2 to a 3 but I only need 3 characters returned if it is BEX)

1111UA01154
1234SA0127-01
1014GL014-01
1355BEX01-11

So after using the MID formula, how would I use a formula to say IF answer = BE, THEN change to "BEX" but if not BE then the original answer is used (UA, SA, or GL).

I'm stumped. Thanks for any help!

 

[Eric W]

Maybe:

=IF(MID(A11,5,2)="BE","BEX",MID(A11,5,2))

 

[Scott Huish]

If the character after the letters is always a 0, then perhaps:

=SUBSTITUTE(MID(A11,5,3),0,"")

 

[Related1]

Maybe:

=IF(MID(A11,5,2)="BE","BEX",MID(A11,5,2))

Whoa. I"m constantly amazed by Excel and people being so skilled at it. Thank you so much!

 

[Eric W]

Glad we could help!