How do you change a formula to text in a cell?
To copy the actual value instead of the formula from the cell to another worksheet or workbook, you can convert the formula in its cell to its value by doing the following: Press F2 to edit the cell. Press F9, and then press ENTER. How do I convert a formula result to a text string in Excel? Convert formula to text string with User Defined Function
Hold down the Alt + F11 keys in Excel, and it opens the Microsoft Visual Basic for Applications window.