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…

LEN wmfexcel

How to add leading zero to fixed number length in Excel?

Pad a column to fixed length with #Excel formula

How to change the width of column in excel

Formula wmfexcel

Fung WONG - Hong Kong SAR, Professional Profile

RIGHT wmfexcel

BeExcellence

RIGHT wmfexcel

i.stack.imgur.com/ICCNS.png

How to change and AutoFit column width in Excel

Pad a column to fixed length with #Excel formula