Free Trial

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #35: Data Cleansing Practice

John_xyz
6 - Meteoroid

Spoiler
my_solution
TanbirJ99
8 - Asteroid

Good data cleansing exercise

 

Spoiler
challenge35_Part1.pngchallenge35part2.png
Pyip
6 - Meteoroid

My Workflow

Neil_Rudd
5 - Atom

My solution

mmueller7337
8 - Asteroid

Maybe I rely too heavily on formula functions?

KathrynMW
8 - Asteroid

Here's my solution.  For the one where you remove descriptive text at the end, I discovered you can use ToNumber in the formula tool, but I decided to try a different method that may be a better option if using as a 'real life' solution at some point.

Spoiler
Challenge 35 Spoiler.png

rickytung
6 - Meteoroid

.

jbagabag
6 - Meteoroid

my solution

danielhoge
8 - Asteroid
Spoiler
Screenshot 2023-07-20 114824.png
AndreeaS
8 - Asteroid
Spoiler
Screenshot 2023-07-20 162530.png