Ask Your Question
0

Separating content column Left , Right error

asked 2019-04-07 17:31:55 +0200

JG101 gravatar image

updated 2019-04-08 12:51:21 +0200

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

C:\fakepath\SEPARATING CONTENT IN COLUMN TO TWO SEPARATE COLUMN 04-07-2019.ods

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2019-04-07 18:10:46 +0200

updated 2019-04-08 12:50:54 +0200

LEFT =ESQUERDA(B8;PESQUISAR("x";B8)-1)

RIGHT =DIREITA(B8;NÚM.CARACT(B8)-PESQUISAR("x";B8))

Arquivo teste

edit flag offensive delete link more

Comments

=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

JG101 gravatar imageJG101 ( 2019-04-08 04:51:38 +0200 )edit

Portuguese language, use google translate LOL.

what's núm.caract ??? =DIREITA(B8;NÚM.CARACT(B8)-PESQUISAR("x";B8))

JG101 gravatar imageJG101 ( 2019-04-08 04:57:44 +0200 )edit
JG101 gravatar imageJG101 ( 2019-04-08 05:22:27 +0200 )edit

all set, TY.

JG101 gravatar imageJG101 ( 2019-04-08 05:26:23 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-04-07 17:31:55 +0200

Seen: 35 times

Last updated: Apr 08