Fine Text between Dashes in Excel

[khanzgem]

Hello,

I need to find out text between the dashes. JAWAD AHMAD SAHIBZADA - Sem-1 - MSEM-F2018 - R.No.MS 155-2018 Fee Deposited. 1.Between 1st & 3rd Dashes ( Sem-1) 2.Between 3rd & 5th Dashed ( MSEM-F2018)

 

[BrianGGG]

Assuming that you can use " - " as the delimiter (rather than just a dash), you can get the two values with the following formulas:
(B112 holds your data):

=TRIM(MID(SUBSTITUTE(B112," - ",REPT(" ",100)),100,100))

returns

Sem-1

and

=TRIM(MID(SUBSTITUTE(B112," - ",REPT(" ",100)),200,100))

returns

MSEM-F2018

 

[khanzgem]

Hello BrainGGG
Thanking you to solve the matter.

Saeed Khan