Challenge #35: Data Cleansing Practice

[StephanieYou]

1. Remove leading zeroes

Spoiler

2. Trim leading zeroes and/or descriptive text at the end

Spoiler

3. If the data value ends with ID, remove the ID

Spoiler

4. If more than 8 chars, remove anything after 8. If only 6, add “SC” to the front.

Spoiler

[julietruan]

Spoiler

[jamesbodolay]

:]

[hlee36]

Attached is my solution.

Thanks

Han

[bo_peng2022]

my solution

[Danielle_Lutz]

35 Solution

[lexi_westendorf]

My solution!

[b83wilson]

Finished

[rhaynes]

my solution

[ntakeda]

My solution using only formula tools.

Spoiler