Multiple formulas within a text string?

Hello - We have a CSV file with a text string and we need to calculate data from another cell using formulas in several locations of the text string.

This is the text string with the formulas marked in blue.

{"administrator":{"role_price":"=C2*1.15"},"customer":{"role_price":""},"Price_Level_B":{"role_price":"=C2*1.6/1.7*1.15"},"Price_Level_D":{"role_price":"=C2*1.1*1.15"},"Price_Level_F":{"role_price":"=C2*1.6/1.8*1.15"},"staff_discount":{"role_price":"=C2*1.15"},"wholesale":{"role_price":"=C2*1.15"},"wholesale_cod":{"role_price":"=C2*1.15"}}

After some research, it appears we cannot have multiple formulas in a single cell, so is there an alternative way we can achieve the above?

Thank you in advance!

Thank you for the welcome!

I think the text2column option might be the best way to go. Do you think splitting up the text and formulas into their own cells then joining them together using the CONCATENATE command would work? This might be the easier option for me since I have used that command before. Appreciate your feedback!