Weekly Challenges

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

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

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

Interesting exercise especially "ID: If the data value ends with ID, remove the ID"

Here's the solution

Quick use of formula tools

Solution for this challenge has been attached to this post.

My solution:

SPOILER

Solutions Attached

Can finally attach files, although cannot edit my previous reply

Challenge #35: Data Cleansing Practice