How to convert a texted formula to an actual value?

[arbelyoav]

Hi,

I'm pulling data from an excel file in SQL server where furmulas are appearing as text and not a claculated numbers.

Can I convert those text formulas into calculated values without writing a complex code?

(Strings lenght are not constant and numbers are different per each cell)

See below example:

Appriciate the help 🙂 

Yoav.

[arbelyoav]

It Works!!

Thanks Amitchandak

[amitchandak · Accepted solution]

@arbelyoav Try Expression.Evaluate in Power Query

https://docs.microsoft.com/en-us/powerquery-m/expression-evaluate