Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =SE(CONT.SE(A1;"*DP-1-*")<>0;ESQUERDA(EXT.TEXTO(A1;LOCALIZAR("DP-1-";A1)+5;NÚM.CARACT(A1));LOCALIZAR("-";EXT.TEXTO(A1;LOCALIZAR("DP-1-";A1)+5;NÚM.CARACT(A1)))-1);ESQUERDA(EXT.TEXTO(A1;LOCALIZAR("--";A1)+2;NÚM.CARACT(A1));LOCALIZAR("-";EXT.TEXTO(A1;LOCALIZAR("--";A1)+2;NÚM.CARACT(A1)))-1))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement