Solved

Concatenate function not showing leading zeros

Posted on 2014-12-31
4
107 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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Automatic sort formula 8 49
Move data from one sheet to another 11 28
VBA: copy range dynamically based on config sheet v2 3 30
Msgbox tickler 7 18
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
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…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

813 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

12 Experts available now in Live!

Get 1:1 Help Now