Hello all,

this is my first question, so if i am any wrong posting or if i fail rules & regulations of forum please excuse me, i will make correct in my further postings

here my problem is i have the below data in my excel sheet
00008025-1183 - BEERS3N - USD
000080252258 - BOHSJD3N - USD
000-0805-08045 - POIOS3N - USD
00009100325-EMDEND-AL MASS INC409 - ROYCCAT2 - CAD
000094010419MUJA SAMA - ROYCCAT2 - USD


how can i get the data from first left character till second occurance of the - (from the right)

so to be clear my expecting output is
00008025-1183
000080252258
000-0805-08045
00009100325-EMDEND-AL MASS INC409
000094010419MUJA SAMA

find from right to left second occurance of "-"

Please sir i tried it a lot but no use with my brain

Please Help me
Thanks in advance
asita