• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 308
  • Last Modified:

Excel - Trim Script

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.
1 Solution
Harry LeeCommented:
Put the following formula in the tblBoundBook!AI column.


should do the job for you.
REIHELPDESKAuthor Commented:
Awesome! I was just watching youtube and testing... Love EE and Youtube.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now