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!
Those functions mainly remove spaces, not what you want here. Looks like all you need is:
Leftwords ( Yourfieldhere ; 1 )
To get all text to the left of the first word separator character ( space, return, punctuation characters....)
Thanks so much!
Retrieving data ...