2 Replies Latest reply on Feb 2, 2017 11:19 AM by oldgustav

    Calculation to remove second part of post code

    oldgustav

      Is there a way to remove the second part of a post code? For example, post code is entered as SA62 5AP but all I want to end up with SA62. I thought I could use Trim or TrimAll but if you can it's beyond me. Hope you can help. Thanks!