Locked - Title does not comply with forum rules
I have a cell which is used to store a phone number the format normally is:
xxx-xxx-xxxx where x= any number. When I brought this database base over from Access approximately 1100 cells came over with a format of this:
xxx-xxxab-xxxx. Where ab equals 78 in 770 different cells and where ab = 70 in 330 cells. I have tried using find/replace along with using wilcards. I can select the records perfectly, but how do I go about getting rid of those two extra characters in those cells? They are always in the same position in each of the 1100 cells. Thanks in advance for any help.
Bookmarks