Challenge #35: Data Cleansing Practice

[DataG8]

Formula tool for every solution.

Spoiler

[tlemare]

Here's my solution.

[shoesnsocks4]

Fun and easy one!

[willdupre]

Some good cleansing tasks / formula use practice.

[Kale_Malcom]

Spoiler

[mcultrera]

Bit confused as many replies seem to be different from the start file on the header.  But anyways here is mine. 

I used Regex on the second part, did not know I could just use 'ToNumber' and it would remove the text altogether.  My Excel brain presumed that would throw an error.  Good to know!

[ascepkova002]

My solution below

[AndrewBanh]

Solution attached.