Please see attached file.
LEFT RIGHT
B C D
C8 , 1.05x1.20 , 1.05 1.20 , =RIGHT(B8,SEARCH(“x”,B8)-1)
C10 , .85x1.25 , .85 .25 , =RIGHT(B10,SEARCH(“x”,B10)-1)
How to fix formula so it always reads correctly
If B10 reads “ 0.85x1.25” then D10 would read correctly , but this will not always be the case for B columns
SEPARATING CONTENT IN COLUMN TO TWO SEPARATE COLUMN 04-07-2019.ods
LEFT =ESQUERDA(B8;PESQUISAR(“x”;B8)-1)
RIGHT =DIREITA(B8;NÚM.CARACT(B8)-PESQUISAR(“x”;B8))
=ESQUERDA(B8;PESQUISAR(“x”;B8)-1)
=DIREITA(B8;NÚM.CARACT(B8)-PESQUISAR(“x”;B8))
this comes back as #NAME?
Please reference to file, would U be able to add file to attachment and reattach
TY
Portuguese language, use google translate LOL.
what’s núm.caract ??? =DIREITA(B8;NÚM.CARACT(B8)-PESQUISAR(“x”;B8))
núm.caract = LEN
:
all set, TY.