Partial cell population


I have a Part Number column The part number is combination of letters and numbers. The majority of the number is the same each time with only the last three digits changing. The column does not run in numerical order as the part number may appear more then once.

Is there a way for the cell to populate the complete part number when just the last three digits are input?

Thanks in advance


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!