Pad a column to fixed length with #Excel formula

Here's the situation: We have a column of values with various lengths, from 1 to 5 letters. We want to convert that into a fixed length of, say 5 letters, padding with zero(s). The following screenshot illustrates the requirement. How would you do it? If "IF" is on top of your mind, please continue to…

Pad a number with zeros - Excel formula

Where to use fixed column width, excel tutorial

Pad a column to fixed length with #Excel formula

How to pad cells to a fixed length in Excel?

wmfexcel, Work smarter by Mastering Functions in Excel

Pad a number with zeros - Excel formula

How to change and AutoFit column width in Excel

Fung WONG on LinkedIn: Add conditional columns with #Excel Power Query

RIGHT wmfexcel

How To Add Leading Zero in Excel - Ajelix