Data Separation

Now we have some realistic data that are FAR more complicated than your original example....

in B2, copied across and down:

=TRIM(MID(SUBSTITUTE("¦"&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($A2,"*es traspasado de*","¦"),"*a*","¦"),"*por*","¦"),"¦",REPT(" ",125)),125*COLUMNS($A:A),125))