Hi Alteryx community - looking for some help here. I have an excel file as an input, but the excel file has a column without any leading letters and leading zeros.
Overall the number of characters should be in total 9 characters: 3 leading letters (in the example below the three leading letters should always be ABC) and 6 overall numbers.
What is happening is in the excel file i am getting only the final pieces of the numbers excluding the leading ABC and any leading zeros. Is there a formula that i can do the After view below?
Before
1234
58678
910
After
ABC001234
ABC058678
ABC000910
