Tag Archives: SWITCH

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

Basic Date Calculations – Power Query vs Excel Formula

Posted on November 19, 2022 by MF

It is quite common to perform date-related calculations when we work with Excel. Before Power Query, we must do it with built-in functions. However, we may not get the results we need with a single function most of the time. … Continue reading →

Rate this:

Posted in Formula, Power Query | Tagged , , , , , , , , , , , | Leave a comment