Help
Rob_Cobb
4 - Data Explorer
4 - Data Explorer
since ‎Feb 28, 2022
‎Nov 29, 2022

User Statistics

  • 1 Posts
  • 0 Solutions
  • 0 Kudos given
  • 0 Kudos received

User Activity

I’m making course codes (like ACT015) from numbers (like 15) and prefixes like “ACT”. The trick is - how to left pad the numbers with 0 when combining them? The part of the formula to add the right number of '0’s: REPT(“0”, 3 - LEN(Number&"")) and th...