Posts by augusto • 1 point

• 0

  votes

  5

  answers

  19696

  views

  A: Removing the last name of a cell

  In English it is best to use the formula SUBST =DIREITA(A3;NÚM.CARACT(A3)-PROCURAR("|";SUBST(A3;" ";"|";NÚM.CARACT(A3)-NÚM.CARACT(SUBST(A3;" ";"")))))

  excel

  answered 5 years, 2 months ago augusto 1