I want to change the formula below to give me the left 3 numbers if col A has a 6 instead of 5 digit code in it, but still return the left 2 only if there is a 5 digit code in col A
<tbody>
</tbody>
Col A | Col B |
15035 | =IF(A1="5522",50,LEFT(A1,2)) |
<tbody>
</tbody>