Thread: Multiple Trimmings

Hi Everybody!

I will pls. need help in trimming certain information contained in 1 cell and putting them each in a column. I could do left, mid & right but this time there is inconsistency in the content of the cell.

I've attached a file which will further give you an idea exactly what I want (formula to be in Column M to P).

Don't hesitate to ask for any clarification.

Thanks

In M3:

=TRIM(LEFT(L3,FIND("-",L3)-1))

in N3:

=TRIM(MID(L3,FIND("-",L3)+1,FIND("->",L3)-FIND("-",L3)-2))

in O3:

=TRIM(MID(L3,FIND("->",L3)+3,FIND("[",L3)-FIND("->",L3)-4))

in P3:

=TRIM(MID(L3,FIND("[",L3)+1,FIND(":",L3)-FIND("[",L3)-1))+0

all copied down.