how to remove 91 in mobile Number in Excel

for best software and Knowledge follow me https://twitter.com/amitechnology http://ami9.com http://facebook.com/ami9com https://plus.google.com/+AmiTechnologyami9 Remove all 91 ,1 from excel you may use the excel function below: =right(text, [num_chars]) For example if your telephone number is a 11-digit number starts with 91, now you only want the left 9-digit number, you may use the function as this: =right(A1, 9) (A1 is where your original 11-digit telephone number locates)