Joined: 26 Jun 2013
Online Status: Offline
Posts: 30
Topic: How to Show First 5 Characters? Posted: 28 Oct 2013 at 9:36am
Hello,
I am working with a zip code field in which some are entered as
90210 and then some are entered as 90210-3413.
Some zip codes have been incorrectly entered in which they may show 90210--3413 or 90210 - 3413.
Is there a formula that will allow me to show only the first five digits?
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum