Fine Text between Dashes in Excel

[khanzgem]

Hello,

[TABLE="width: 256"]
[TR]
[TD][TABLE="width: 256"]
[TR]
[TD]I need to find out text between the dashes.

[TABLE="width: 256"]
[TR]
[TD]JAWAD AHMAD SAHIBZADA - Sem-1 - MSEM-F2018 - R.No.MS 155-2018 Fee Deposited.[/TD]
[/TR]
[TR]
[/TR]
[/TABLE]
1.Between 1st & 3rd Dashes ( Sem-1)
2.Between 3rd & 5th Dashed ( MSEM-F2018)

[/TD]
[/TR]
[/TABLE]
[/TD]
[/TR]
[/TABLE]

 

[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 [TABLE="width: 148"]
[TR]
[TD="width: 148"]Sem-1[/TD]
[/TR]
[/TABLE]

and

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

returns
[TABLE="width: 148"]
[TR]
[TD="width: 148"]MSEM-F2018[/TD]
[/TR]
[/TABLE]

 

[khanzgem]

Hello BrainGGG
Thanking you to solve the matter.

Saeed Khan