Need to delete 2 characters from the middle of a cell.
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.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1