How to Find Between 3rd & 5th Dash

[khanzgem]

Assalam o Alaikum ( May Piece Mercy and Blessing of God on You)

How to find with the help of formula between 3rd & 5th Dash ( Red Colored )

MUHAMMAD SABEEL AFRIDI - Sem-1 - MSEM-F2017 - R.No.MS 48-2017

UMER FAROOQ - Sem-1 - MSCS-F2017 - R.No.MS 49-2017 Fee Deposited.

JAHANGIR KHAN - Sem-1 - MSEE-F2017A - R.No.MS 47-2017 Fee Deposited.

<colgroup><col></colgroup><tbody>
</tbody>

 

[Vbagreenhorn1]

try this:

=LEFT(MID(MID(A1,SEARCH("-",A1)+2,LEN(A1)-SEARCH("-",A1)),SEARCH(" ",MID(A1,SEARCH("-",A1)+2,LEN(A1)-SEARCH("-",A1)))+3,LEN(MID(A1,SEARCH("-",A1)+2,LEN(A1)-SEARCH("-",A1)))-SEARCH(" ",MID(A1,SEARCH("-",A1)+2,LEN(A1)-SEARCH("-",A1)))),SEARCH(" ",MID(MID(A1,SEARCH("-",A1)+2,LEN(A1)-SEARCH("-",A1)),SEARCH(" ",MID(A1,SEARCH("-",A1)+2,LEN(A1)-SEARCH("-",A1)))+3,LEN(MID(A1,SEARCH("-",A1)+2,LEN(A1)-SEARCH("-",A1)))-SEARCH(" ",MID(A1,SEARCH("-",A1)+2,LEN(A1)-SEARCH("-",A1)))))-1)

 

[admiral100]

Hi,

You can try this:

=TRIM(MID(SUBSTITUTE(SUBSTITUTE(A1,"-","*",3),"-","!",4),FIND("*",SUBSTITUTE(SUBSTITUTE(A1,"-","*",3),"-","!",4))+1,FIND("!",SUBSTITUTE(SUBSTITUTE(A1,"-","*",3),"-","!",4))-FIND("*",SUBSTITUTE(SUBSTITUTE(A1,"-","*",3),"-","!",4))-1))

 

[Rick Rothstein]

For the particular data you are trying to retrieve, this formula should work...

=SUBSTITUTE(TRIM(MID(SUBSTITUTE(A1,"-",REPT(" ",200)),600,400))," ","-")

 

[Fennek]

Hi,

just to find the beginning of the red string: (the examples in column A)

in B1: =mid(A1;find("- ",A1, find("- ", A1)+1)+2)

regards

 

[admiral100]

A shorter way:-

=MID(A1,FIND("*",SUBSTITUTE(A1,"-","*",{3,5}))+1,12)

 

[stunnrock]

Another option:

=TRIM(MID(A1,FIND("¬",SUBSTITUTE(A1,"-","¬",3))+1,FIND("¬",SUBSTITUTE(A1,"-","¬",5))-FIND("¬",SUBSTITUTE(A1,"-","¬",3))-1))

 

[khanzgem]

Thank You, Its Perfect