combining formulas

Question

Hello,

I would like to combine two different formulas together but I am not sure how to do so. With the first formula I am pulling information from multiple cells on a different tab and combing them into one cell. I need to combine this with a second formula that will stop leading zeroes from disappearing from my data. How can I do this?

First Formula:

=CONCATENATE('Converter Tab'!A16&"-"&'Converter Tab'!B16&"-"&'Converter Tab'!C16&"-"&'Converter Tab'!D16&"-"&'Converter Tab'!E16)

Second Formula:

=TEXT(A14, "00")&"-"&TEXT(B14, "0")&"-"&TEXT(C14, "0")&"-"&TEXT(D14, "00000")&"-"&TEXT(E14, "0000")

Answer 1

To combine your two formulas while ensuring that leading zeros are preserved, you can modify your first formula to incorporate the TEXT function from your second formula. Here’s how you can do it:

=TEXT('Converter Tab'!A16, "00") & "-" & TEXT('Converter Tab'!B16, "0") & "-" & TEXT('Converter Tab'!C16, "0") & "-" & TEXT('Converter Tab'!D16, "00000") & "-" & TEXT('Converter Tab'!E16, "0000")

This formula will concatenate the values from the specified cells in the 'Converter Tab', while applying the TEXT function to each cell to format them with leading zeros as specified.

Make sure to replace A16, B16, C16, D16, and E16 with the appropriate cell references if they differ in your actual spreadsheet.

---

References:

• DAX overview
• Add reference methods to cell values