: Right-click and choose the Values icon (usually a "123" icon) or press Alt + E + S + V and then Enter . Software and Tools
: 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. Download 91 remove Formula Excel File xlsx
: Press Ctrl + H , type +91 (include the space) in the "Find what" box, leave "Replace with" blank, and click Replace All . : 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 ). : Press Ctrl + H , type +91