Excel Magic Trick 1414

Power Query Text.PadStart Function to Correctly Format Account Numbers

DESCRIPTION

See how to Convert 35 & 100 to 00-035 & 00-100 using Power Query, a Custom Column and the Text.PadStart Power Query Function.

WORKBOOKS

Download “Excel Magic Trick 1411-1415” Excel-Magic-Trick-1411-1415.zip – Downloaded 63 times – 4 MB







Be the first to comment

Leave a Reply