13|EXCEL – Transform Your Data!

[Braden_Jones]

Fun challenge! It was nice that all the date was uniform. My formulas would not have worked otherwise

[Keith_Clove]

Time to complete: 10 minutes
Rating: Beginner

Challenge13_Transform_Your_Data! (1).xlsx (496.1 KB)

[Nolan_Ward]

Time: 15 min
Difficulty: easy
Challenge13_Transform_Your_Data!D.xlsx (547.2 KB)

[Noah_Bluth]

Time to Complete: 15 min
Difficulty: Beginner

Challenge13_Transform_Your_Data!.xlsx (579.9 KB)

[Cozette_Rogers]

Challenge13_Cozette_Rogers.xlsx (546.4 KB)
Here is my solution!

[Vincent_Hamer]

Time to complete: 10 min
Challenge13_Transform_Your_Data!.xlsx (550.5 KB)

Difficulty: easy

[Jacob_Sumsion]

Challenge13_Transform_Your_Data!.xlsx (628.3 KB)
Loved the challenge!

[Crew_Jensen]

Time to Complete: 15 Minutes
Difficulty: Beginner
Challenge13.xlsx (558.6 KB)

[Myla_Schroeppel]

Challenge13_Transform_Your_Data!.xlsx (539.2 KB)
For 3, instead of using =REPLACE, I used =REGEXREPLACE(C2,“\d\d\d-\d\d”,“XXX-XX”)

[Yangshi_Liu]

Thanks! It works now.