adnan_shaikat
New Member
- Joined
- Sep 10, 2023
- Messages
- 2
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
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.
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.