Solved

Concatenate function not showing leading zeros

Posted on 2014-12-31
4
106 Views
Last Modified: 2014-12-31
hi Folks
I have a file with a link ID. It is a concatenated field compiled of three fields. One of the fields has leading zeros and I need my LinkID field to show the leading zeros. e.g. In the account field I have 0010, what appears in my link ID field is 10. How can I get it to show 0010 in the Link ID. File attached.
Thanks as always :-)
LinkID-not-showing-full-number.xlsx
0
Comment
Question by:agwalsh
  • 2
4 Comments
 
LVL 11

Accepted Solution

by:
Wilder1626 earned 250 total points
ID: 40525261
Hi
Try this way as text format.
="SCP"&"|"&TEXT(B2,"0000")&"|"&C2
0
 
LVL 43

Assisted Solution

by:Saqib Husain, Syed
Saqib Husain, Syed earned 250 total points
ID: 40525264
Try

="SCP"&"|"&TEXT(B2,"0000")&"|"&C2
0
 

Author Closing Comment

by:agwalsh
ID: 40525297
Brilliant. Have given equal marks since they are the same but have given Best to Wilder 1626 because he/she got there first :-)
0
 
LVL 11

Expert Comment

by:Wilder1626
ID: 40525460
I'm glad i was able to help.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
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…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

947 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

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now