Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHere is my solution to the challenge above;
1. Remove leading zeros using IIF:
2. Trim leading zeroes and/or descriptive text at the end using RegEx
3. Remove ID:
4. Remove & replace characters based on the length of strings: