?
Solved

Excel - Trim Script

Posted on 2013-12-13
2
Medium Priority
?
294 Views
Last Modified: 2013-12-13
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.
0
Comment
Question by:REIHELPDESK
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 12

Accepted Solution

by:
Harry Lee earned 800 total points
ID: 39717753
Put the following formula in the tblBoundBook!AI column.

=if(tblBoundBook!AH1="","",left(tblBoundBook!AH1,3)&right(tblBoundBook!AH1,5))

should do the job for you.
0
 

Author Comment

by:REIHELPDESK
ID: 39717811
Awesome! I was just watching youtube and testing... Love EE and Youtube.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question