Saturday, June 6, 2015

how to remove 91 from mobile number in excel

how to remove +91 from mobile number in excel




Worksheet Formulas
CellFormula
B2=IF(AND(LEN(A2)=12,LEFT(A2,2)="91"),RIGHT(A2,10),IF(AND(LEN(A2)=10,LEFT(A2,1)="9"),A2,""))
Posted by at

26 comments:

  1. UnknownOctober 18, 2015 at 1:11 AM

    Nice it works thanks for this informational work

    ReplyDelete
  2. ParitoshNovember 8, 2016 at 3:11 AM

    can u show with screen shot of few numbers ?

    ReplyDelete
  3. ParitoshNovember 8, 2016 at 3:12 AM

    Pl mail me a sample excel with say 5 numbers to paritosh4india@gmail.com.

    ReplyDelete
  4. Devinder SainiNovember 9, 2016 at 1:26 AM

    Hi Paritosh,

    Just put a number in Cell A2 like : 919988005056

    Put it in Cell B2 =IF(AND(LEN(A2)=12,LEFT(A2,2)="91"),RIGHT(A2,10),IF(AND(LEN(A2)=10,LEFT(A2,1)="9"),A2,""))

    That's it.

    You got result in Cell B2 as 9988005056

    If need any other help. tell me.

    Thanks

    ReplyDelete
  5. AdminDecember 13, 2016 at 2:07 AM

    Guys why you making things so complicated Just do as below
    Suppose Your number is +919911852444, Now you want to remove +91, Means you want 9911852444, Do as given below below

    =Right(Cell,10) Note:-Cell means your number Column Eg:- =(RIGHT(A2,10)

    ReplyDelete
  6. OMFICO - Complete Financial Investments SolutionApril 15, 2017 at 12:00 AM

    Thanks for support! It works.

    ReplyDelete
  7. UnknownSeptember 1, 2017 at 5:47 AM

    This is really really simple and can be understand by a lay man

    ReplyDelete
  8. UnknownMay 30, 2018 at 4:09 AM

    Plz mail me a sample excel with say 10 numbers to venkatadudipalli@gmail.com

    ReplyDelete
  9. Homeseek RealtorsOctober 17, 2018 at 2:30 AM

    This comment has been removed by the author.

    ReplyDelete
  10. VishuFebruary 28, 2019 at 4:00 AM

    guys just use =right(A1,10) and see the magic.....

    ReplyDelete
  11. UnknownApril 4, 2019 at 10:18 AM

    Very Simple formula
    in A2 =A1-910000000000

    ReplyDelete
  12. PushkrajApril 9, 2019 at 10:49 PM

    https://blog.domainregistrationdatabase.com/how-to-remove-91-in-excel-sheet/

    ReplyDelete
  13. UnknownJuly 19, 2019 at 1:33 AM

    not working for 8820000000

    ReplyDelete
  14. UnknownJuly 30, 2019 at 12:05 AM

    how to remove +91 from mobile number in excel

    ReplyDelete
  15. UnknownNovember 14, 2019 at 3:23 AM

    How to apply this formula for entire sheet
    Bcz it is working for only one cell.

    ReplyDelete
  16. AdminSeptember 7, 2020 at 1:39 AM

    Very useful and nice article, want to get all India every updates and Latest news and inspiring
    Trending about govt jobs just check with the voyage and receive all the updates on the single click.
    you can check this for various viral news and Stuff
    BSR City

    ReplyDelete
  17. AdminSeptember 7, 2020 at 1:40 AM

    Very useful and nice article, want to get all USA every updates and Latest news and inspiring
    Biography about govt and US jobs just check with the voyage and receive all the updates on the single click.
    you can check this for various viral news and Stuff
    viral mirrors

    ReplyDelete
  18. AnonymousSeptember 23, 2020 at 3:04 AM

    Formula worked perfectly! Thanks.

    ReplyDelete
  19. sureshDecember 24, 2020 at 3:11 AM

    Very useful and nice article, want to get all India every updates and Latest news and inspiring
    Trending about govt jobs just check with the voyage and receive all the updates on the single click.
    you can check this for various viral news and Stuff

    ReplyDelete
  20. sureshDecember 24, 2020 at 3:16 AM

    Mobile Me cricket kaise dekh sakte hai bina internet ke

    ReplyDelete
  21. AnonymousJuly 22, 2021 at 4:04 AM

    its really working very easily...

    ReplyDelete

Subscribe to: Post Comments (Atom)