Extract Data After Hyphen Mark "-"

[muhammad susanto]

I'am looking for excel formula to extract this data below after hyphen mark :
mark "-" red font

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]data[/TD]
[TD]after formula[/TD]
[/TR]
[TR]
[TD]SEKTOR KEHUTANAN - DINAS KEHUTANAN PROV.RIAU[/TD]
[TD]DINAS KEHUTANAN PROV.RIAU[/TD]
[/TR]
[TR]
[TD]SEKTOR KEUANGAN - DEPKEU CQ DJKN EKS BDL[/TD]
[TD]DEPKEU CQ DJKN EKS BDL[/TD]
[/TR]
[TR]
[TD]SEKTOR TENAGA KERJA - BPJS KETENAGAKERJAAN RIAU I[/TD]
[TD]BPJS KETENAGAKERJAAN RIAU I[/TD]
[/TR]
[TR]
[TD]SEKTOR KEHUTANAN - KEMENTERIAN KEHUTANAN RI[/TD]
[TD]KEMENTERIAN KEHUTANAN RI[/TD]
[/TR]
</tbody>[/TABLE]

helps, much appreciated,,

m.susanto

 

[bosco_yip]

B2, formula copy down :

=MID(A2,FIND("-",A2)+2,255)

 

[muhammad susanto]

B2, formula copy down :

=MID(A2,FIND("-",A2)+2,255)

hi Bosco, very quickly...thank u very much!! Working well..

 

[bosco_yip]

You are welcome.