Hello carcanfloat,

Welcome to the forum!
To recap your request you want to replace the formulas in cells A1:A100 with their values, correct?