Find and Mid to extract

Dear Friends,

Please I need to find "-" and extract the character, I do not want to use convert Text to columns wizard by using delimited characters, I need the formula which i can put in column B1

for example:
in column A1 = "Mr.Sam - Further to our conversation - I wish to confirm that - we would like to - arrange a demo"
it has 4nos "-" in a A1 cell, might be more "-" in some of the lines.
how could i extract only the third part after 2nd hyphen "-"
I want
in column B1 = "I wish to confirm that"
in column C1 = "Further to our conversation"
in column D1 = "Mr.Sam"

this formula work for D1 = "MR.Sam" =TRIM(IFERROR(LEFT(A1,(FIND("-",A1)-1)),LEFT(A1,8)))

Thanks

I do not want to use convert Text to columns wizard, I need the formula

Thankyou very much Alkey

please can you also give the formula if i want to extract in sequence one after another same function as used in Text to Columns

Hia, again I need some help please,
I have following raw data in one column
A1 = a:1:{s:16:"m2epro_extension";a:1:{s:5:"items";a:1:{i:0;a:2:{s:7:"item_id";s:12:"251130406951";s:14:"transaction_id";s:13:"1593701358015";}}}}

I need to extract Item_Id = 251130406951 in column B1 & transaction_id = 1593701358015 in column C1
so need formula which i will put in cell B1 & C1

Row/Col	A	B	C
1	a:1:{s:16:"m2epro_extension";a:1:{s:5:"items";a:1:{i:0;a:2:{s:7:"item_id";s:12:"251130406951";s:14:"transaction_id";s:13:"1593701358015";}}}}	251130406951	1593701358015

Great Thank you