Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEASolutions below:
1. Select statement to convert string to number - automatically drops leading 0.
2. Data Cleansing (it is "Data Cleansing Practice" after all) to remove anything except numbers then, same trick as 1 above, Select.
3. Formula using TrimRight to remove trailing ID.
4. Formula using nested IF to only keep 8 characters AND to append leading SC for strings equal to 6 characters.