Convert Formula To Text String With Find And Replace Feature

Supposing you have a range of formulas in Column C, and you need to show the column with original formulas but not their calculated results as following screenshots shown:

To solve this job, the Find and Replace feature may help you, please do as follows:

1. Select the calculated result cells that you want to convert to text string.

2. Then press Ctrl + H keys together to open the Find and Replace dialog box, in the dialog, under the Replace tab, enter equal = sign into the Find what text box, and enter '= into the Replace with text box, see screenshot:

3. Then click Replace All button, you can see all the calculated results are replaced with the original formula text strings, see screenshot:

转载自：https://www.extendoffice.com/documents/excel/822-excel-convert-formula-to-text-string.html