des-concatenar Numbers

[Emmanuel gongora]

Hola amigos, buenas tardes.. quisiera saber si me pueden ayudar a des-concatenar la siguiente columna:

PAGO COMERCIAL MOTOS /AH000300116 - 1

quisiera que se divida en una celda PAGO COMERCIAL MOTOS

y en otra celda AH000300116 - 1

Muchas gracias.


-----------------------------------------------------------------------------------

Hi guys .. can help me to un-concatenate the following column:

PAYMENT COMMERCIAL MOTORS / AH000300116 - 1

I would like it to be divided into a cell COMMERCIAL PAYMENT MOTOS

And in another cell AH000300116 - 1

Thank you very much.

[Glenn Kennedy]

With data in A1, use this in B1:


=TRIM(LEFT(A1,FIND("/",A1)-1))

and this in C1

=TRIM(MID(A1,FIND("/",A1)+1,255))

[Sam Capricci]

I would just use text to columns with / as the delimiter.

EDIT: provided the cell in the next column is empty, otherwise it will overwrite the cell.

[Emmanuel gongora]

Thanks guys, I work.