How to make formula result permanent in excel

Make cell’s content formula (ie “=blah blah blah”); when you get value you need copy it to clipboard, then choose paste special instead of normal paste and uncheck pasting formulas.