IF a cell in the data contains X number of characters

[missteran]

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

[binuacs · Accepted solution]

@missteran