Rajesh Sabbani

how to remove 91 from mobile number in excel Method 1:  Find and Replace  (Fastest)   Select the range  of phone numbers. Press  Ctrl + H  to open the Find and Replace dialog. In "Find what," type  +91  or just  91  (depending on your data format). Leave "Replace with"  empty . Click  Replace All . Note: If there are spaces, try replacing  +91  (with a space) or using  *  as a wildcard (e.g.,  +91*  in Find what).   Method 2:  RIGHT Formula  (For 10-digit numbers)   If your numbers are in column A, enter this formula in column B: =RIGHT(A1, 10)   Drag the formula down to apply to all cells. Copy the new cells and  Paste as Values  to remove the formula.   Remove +91  Remove Space between Use Find and Replace 

  Method 1: Using Find & Replace - Spacebar & Empty  This method is the quickest as it doesn't require a helper column.   Select  the cell, range, or entire column where you want to remove the spaces. Press  Ctrl  +  H  (or  Cmd  +  H  on a Mac) to open the "Find and Replace" dialog box. In the  "Find what"  field, press the  spacebar once  to insert a single space character. Ensure the  "Replace with"  field is  completely empty . Click the  "Replace All"  button. A confirmation message will appear showing how many replacements were made.   Method 2: Using the SUBSTITUTE Function The  SUBSTITUTE  function creates a new cell with the data cleaned, leaving your original data untouched until you copy the new values over.   Click an empty cell in a new column (a "helper column") next to your data. In that cell, enter the formula  =SUBSTITUTE(A1," ","") ,...