Challenge #35: Data Cleansing Practice

[jrlindem]

After completing, I scrolled through lots of the other responses and there are so many great and creative ways to solve these four problems.  I used a combination of formula functions and bit of regex:

Spoiler

[SWACorgizilla]

My rework of the solution.  :)

[Clara-C]

solution for 35

[jackhunter2905]

Done

[christouf03]

Finished ! 

[faisvk007]

solution
regex is tricky and useful