Tag Archives: REPT

Pad a column to fixed length with #Excel formula

Posted on June 3, 2023 by MF

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 … Continue reading →

Rate this:

Posted in Excel 365, Formula | Tagged , , , , , | Leave a comment

Extract last word from a text string

Posted on November 17, 2014 by MF

There are many cases that we may just want the last word from a text string.  Typical example would be something like the last row in the above screenshot: There are many codes at the end of a text string … Continue reading →

Rate this:

Posted in Excel Tips, Formula | Tagged , , , | 5 Comments