Newbies FM NewB Posted April 10, 2002 Newbies Posted April 10, 2002 My question is when zip codes are entered with 5 numbers and then the new 4 numbers but wihtout the hypen is there anything you can do to automatically enter the hypen without going through all the data? I am self teaching, new and getting frustrated. ex:48825-4801 (?) Thank you
BobWeaver Posted April 10, 2002 Posted April 10, 2002 You can use this formula to check for and insert the hyphen: Case(Length(ZipCode)>5 and PatternCount(ZipCode,"-")=0, Left(ZipCode,5) & "-" & Middle(ZipCode,6,4), ZipCode) You can either use this formula in a new calculated formatted zip code field, or as the formula in a replace command to replace the original data in the same field. If you are going to directly change the original data, make sure you back up your file first.
Recommended Posts
This topic is 8249 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now