you have to be assuming that all the phone numbers are valid, then simply remove all the non-numeric charactors first, then reformat it based on the length of the remains, say, 10=3-7;
13=3-7ext3; 11=1-800-7 etc. and so on
This post has been archived. It cannot be replied.
Page address has been copied.
To share, click to copy page address.
Share Online by QR Code
Back To Topic:
a small VB question
Back To Forum: