How can we Remove Country Code From Phone Number In Excel? And How can we write VBA Codeto Remove Country Code From Phone Number In Excel?
Share
Sign Up to our social questions and Answers Engine to ask questions, answer people's questions, and connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
shree
This is how you can write simple VBA Code to remove country codes from a list of phone numbers in Excel Sheet.
Sub RemoveCountryCode()
Selection.Replace What:=”+91-“, Replacement:=””, LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False, FormulaVersion:=xlReplaceFormula2
End Sub