Forum Discussion
exel formula
am trying to combine left formula with a check. IE column B contains name ABC123 or XYZ123. I want to select the left 3 characters, but also want to check to say if the result is ABC then make the an...
That should be
=IF(LEFT(B1,3)="ABC",NEW",LEFT(B1,3))
Slightly simpler:
=SUBSTITUTE(LEFT(B1,3),"ABC","NEW")