Want to get involved? We're always looking for ideas and content for Weekly Challenges.
Regex, text to column, formula
This was fun cleaning data using multiple tool approach.
my solution here.
Re: Challenge #35: Data Cleansing Practice
Here you go
Thanks for an easy one:) I used formula tool for the win. Used some standard formulae for all but the last. Used an If statement to get the last one.
Here is my solution