Excel Magic Trick 1411: Power Query Add Prefix to Account Numbers in Column
Download File:
Start File: https://excelisfun.net/files/EMT1411S...
Entire page with all Excel Files for All Videos: https://excelisfun.net
See how to add the prefix “00-“ to a column of Account Numbers using Transform, Text Column, Format, Add Prefix feature in Power Query (Get and Transform).
Convert Number Account Numbers to Text Account Numbers with a Prefix.