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. The 12,500 other cells came over normally and display correctly. 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.
Bookmarks