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!
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!