Posts by Uilian_Agner • 1 point

• -2

  votes

  1

  answer

  24

  views

  A: Procv without the last character

  =SE(SEERRO(DIREITA(A2;1)*1;0)=0;PROCV(ESQUERDA(A2;NÚM.CARACT(A2)-1);$I:$J;2;0);PROCV(A2;$I:$J;2;0)) This formula evaluates whether the last character is numeral or not, if it cannot touch its base.…

  excel procv

  answered 3 years, 8 months ago Uilian_Agner 1