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

PrachiD
8 - Asteroid

Regex, text to column, formula

Crichardson
6 - Meteoroid

Challange 35

KorkuSep
7 - Meteor

This was fun cleaning data using multiple tool approach.

Spoiler
2023-04-11_15-37-20.jpg
Lenusa
8 - Asteroid

my solution here.

siddharth_28
8 - Asteroid

Re: Challenge #35: Data Cleansing Practice

Biplab19
7 - Meteor

Completed!

RachelBrinkley
6 - Meteoroid

Here you go

nvijay5757
7 - Meteor

Data cleansing

HardikJani
8 - Asteroid

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.

mbit83
6 - Meteoroid

Here is my solution