Hi,

I have a problem with a huge set of data in a quite variable text format in Excel. I have been able to get the data to look like a normal mathematical function with a bunch of functions. Now I have cells which for example say: "=500/1000" (without the quotation marks). But I haven't found a way to calculate these values. I know I could do it by copying the cells and then paste special using the "values" selection, but that does not satisfy me as it will be very tedious as there's a lot of data and in many different sheets. Also that method requires me to double click each cell and then press enter for Excel to calculate it. I am looking for a way to make it fully automatic, so I could just make the calculations work without any need for any manual work.

Is there a way to solve this? Preferably without VBA as I do not understand anything about those.

Thanks.