asked on modify current formula to add additional step part 2
Hi Experts
I need to add to the following formula =IF(AND(OR(LEN(C2)=8,LEN(C
One more step...
If cell c2 has BAV(o123456 from the right then remove and leave BAV only..incorporate into above formula.
I need to add to the following formula =IF(AND(OR(LEN(C2)=8,LEN(C
One more step...
If cell c2 has BAV(o123456 from the right then remove and leave BAV only..incorporate into above formula.
Microsoft Excel
Last Comment
Rgonzo1971
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
then try
EDIT corrected code
=IF(AND(OR(LEN(C2)=8,LEN(C2)=7),OR(ISNUMBER(SEARCH("o",LEFT(C2,1),1)),ISNUMBER(SEARCH("e",LEFT(C2,1),1)))),SUBSTITUTE(C2,C2,"-"),IF(AND(LEFT(C2,4)="BAV(",OR(LEN(C2)=12,LEN(C2)=11),OR(ISNUMBER(SEARCH("o",MID(C2,5,1),1)),ISNUMBER(SEARCH("e",MID(C2,5,1),1)))),SUBSTITUTE(C2,C2,"BAV"),C2))
EDIT corrected code
Formula not working...no end result