Extract Multiple text from a cell if condition met

[adnan_shaikat]

A1.Tot Trans Ct = 2; Round Ct % = 100%; Round Amt % = 100%; Effct Risk Lv = 6;Tot Trans Amt = 500
A2.Round Ct % = 100%; Round Amt % = 100%;Tot Trans Ct = 2;Actvty Risk Lv= 5;Tot Trans Amt = 10.00; Effctv Risk Lv= 6

there are 02 text into diff cell A1 and A2, Where i need to extract value of "Tot Trans Ct" and "Tot Trans Amt" (Value after= sign) from the both A1 and A2.....the formula should be dynamic since both text can be place in any where in the cell.

 

[adnan_shaikat]

output required: Tot Trans C=2 ;Tot Trans Amt = 500 (A1 CELL )
Tot Trans C=2 ;Tot Trans Amt = 10 (B1 CELL )