Objective: Trim an Excel spreadsheet field
We have a field that contains 15 digits and I need to keep the first three and last five digits and store into another field in the same row.
Current Field = "=tblBoundBook!AH"
Target / Desired Field = "=tblBoundBook!AI"
Would prefer to to have this setup in a function whereas when I leave the current field the target field is updated with the first three and last five digits.