This tool converts a cell formula into its text value.
This way, you can copy the formula to other cells without automatically shifting the columns and rows.
Before conversion:
After conversion:
Click
Using this tool will definitely save you time and effort. However, the actual time savings will depend on how often you use it. Excel , the amount of data you work with, and how often you use this tool.
You can use the utility
After that, this function will be available in all files that are opened in Excel .