Advertisement
Guest User

Untitled

a guest
Aug 17th, 2017
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.24 KB | None | 0 0
  1. =ESQUERDA(A1;PROCURAR(",";A1)) & (VALOR(EXT.TEXTO(A1; PROCURAR(",";A1)+1; PROCURAR(",";A1;PROCURAR(",";A1)+1)-1 - PROCURAR(",";A1)))+1) & DIREITA(A1;NÚM.CARACT(A1)-PROCURAR(",";A1)-PROCURAR(",";DIREITA(A1;NÚM.CARACT(A1)-PROCURAR(",";A1)-1)))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement