Trim text

[isameer247]

HI,

I am stuck in a sheet if anyone can help me out i will be oblidged.

I am attaching test file here,

I have some data in E column with some formule, but I want a perticular text to next column

Kindly help.

Regards,

[samba_ravi]

=LEFT(RIGHT(E2,LEN(E2)-FIND("|",E2)),FIND("-",RIGHT(E2,LEN(E2)-FIND("|",E2)))-1)
Try this and copy towards down

[FDibbins]

Probably better ways to do this, but this works...
=LEFT(MID(E2,FIND("|",E2,1)+1,99),FIND("-",MID(E2,FIND("|",E2,1)+1,99),1)-1)

[shukla.ankur281190]

use this formula

=REPLACE(LEFT(RIGHT(E2,LEN(E2)-FIND("|",E2)),FIND("-",RIGHT(E2,LEN(E2)-FIND("|",E2)))),FIND("-",LEFT(RIGHT(E2,LEN(E2)-FIND("|",E2)),FIND("-",RIGHT(E2,LEN(E2)-FIND("|",E2))))),1,"")

[FDibbins]

Happy to help, thanks for the feedback

[vlady]

maybe also this??

=MID(LEFT(E2,LEN(E2)-14),41,99)