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

Siobhan_Purcell
8 - Asteroid
Spoiler
Spoiler
Siobhan_Purcell_0-1582329435619.png

 

A nice little data cleansing challenge using simple formula tools. Here's my solution

Inactive User
Not applicable

I did some RegEx yet the leading zero's are always difficult.  

AnjaTABARD
7 - Meteor
 
RobertOdera
13 - Pulsar
 
Preethi07
6 - Meteoroid

Attached is the solutions file

Himanshu_1984
8 - Asteroid

Hi

 

please find my reply

HCowley
6 - Meteoroid

That was fun!  I liked the 4 parts to the task that led on from each other.

bschindler
6 - Meteoroid

My solution...

zalloum1
6 - Meteoroid

Hi,

 

Attached the suggested solutoin from my side :).

 

Regards,

tfmckernan
5 - Atom

Here's my solution!