求问各位大 神,在A2这种复杂的字符串里,如何用Excel公式提取出B2,C2这两个值?

字符串如下:
[{"tax_fee": "0", "quantity": 1, "pay_price": "1393.31", "sale_price": "1546", "coupon_infos": [{"type": 6, "price": "152.69", "promotion_id": 22973}], "reduce_amount": "0", "subsidy_price": "152.69", "activity_infos": [{"type": 99, "price": "0", "value": "0", "promotion_id": 22973}], "settlement_amount": "0", "brand_coupon_price": "0", "merchant_coupon_price": "0", "platform_coupon_price": "152.69", "promotion_reduce_price": "0", "merchant_promotion_price": "0", "platform_promotion_price": "0", "merchant_preferred_coupon_price": "0", "external_merchant_discount_amount": "0", "external_platform_discount_amount": "0"}]