Challenge #35: Data Cleansing Practice

[bajajankit]

Solution Attached

[elaineyuan]

Great data cleaning practice using regex.

Spoiler

[mgaronson]

Spoiler

String functions!

[NatalieT]

My solution

[katestrohm]

1. 

2. 

3.

4.

[Antoinette]

Formulas used:
TrimLeft to remove leading characters
TrimRight to remove trailing characters
PadLeft to add leading characters
Left to retain X number of leading characters

[Ray_Pospisil]

solution

[Ray_Pospisil]

correction of my mistake on task 3

[mertshepard]

Solution attached.

[mindyzhang99]

My solution without using RegEx tool