Want to get involved? We're always looking for ideas and content for Weekly Challenges.
Great data cleaning practice using regex.
Formulas used:TrimLeft to remove leading charactersTrimRight to remove trailing charactersPadLeft to add leading charactersLeft to retain X number of leading characters
correction of my mistake on task 3
My solution without using RegEx tool