: Right-click and choose the Values icon (usually a "123" icon) or press Alt + E + S + V and then Enter . Software and Tools
While built-in Excel features are usually sufficient, some specialized tools exist for bulk cleaning: How to Remove Formula in Excel and Keep Values Download 91 remove Formula Excel File xlsx
If your goal is to clean up a list of Indian mobile numbers, you can use these common methods: : Right-click and choose the Values icon (usually
If you need to strip all formulas from an .xlsx file before sharing it, the standard process is: the cells or the entire sheet ( Ctrl + A ). Copy the data ( Ctrl + C ). : Type the 10-digit number without the "91"
: Type the 10-digit number without the "91" in the adjacent cell, press Enter , and then press Ctrl + E . Excel will recognize the pattern and remove the prefix for the entire column.