a4aniruddh
New Member
- Joined
- Jun 1, 2010
- Messages
- 8
Hi,
I am a beginner in VB. I need help in phone number formatting in excel VBA. Below is my requirement.
My requirement is.
I am getting phone numbers in one sheet in row for eg A1:A50
I need to prefix std codes if needed. for example if number is 25736305 from bangalore. I need to add 080. Final final output should be 08025736305. If it is already prefixed then no need to prefix once again.
Also it should validate the number. That is after adding std the number length should not exceed 10 digits. Because in India the phone number length is 10. I need that invalid length number in different sheet or workbook and remove from original.
Request your help on this on how to achieve this on excel vba.
I am a beginner in VB. I need help in phone number formatting in excel VBA. Below is my requirement.
My requirement is.
I am getting phone numbers in one sheet in row for eg A1:A50
I need to prefix std codes if needed. for example if number is 25736305 from bangalore. I need to add 080. Final final output should be 08025736305. If it is already prefixed then no need to prefix once again.
Also it should validate the number. That is after adding std the number length should not exceed 10 digits. Because in India the phone number length is 10. I need that invalid length number in different sheet or workbook and remove from original.
Request your help on this on how to achieve this on excel vba.