core.noscript.text
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
Regex, text to column, formula
Challange 35
This was fun cleaning data using multiple tool approach.
my solution here.
Re: Challenge #35: Data Cleansing Practice
Completed!
Here you go
Data cleansing
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