13|EXCEL – Transform Your Data!

[Amber_Jones]

Awesome challenge! I enjoyed being able to work on formulas we’ve been practicing in class. I mainly used TEXTBEFORE and TEXTAFTER for my solutions.

Challenge13_Transform_Your_Data!.xlsx (566.2 KB)

[Caleb_McKay]

I enjoyed this practice text manipulation! I like using TEXTBEFORE and TEXTAFTER as they are very powerful and easy to use.

Challenge13_Transform_Your_Data!.xlsx (509.6 KB)

[Aaron_Williams]

Here is my solution, great challenge! TechHub_ETLChallenge.xlsx

[Garrett_Elkins]

Challenge13_Transform_Your_Data!.xlsx (509.4 KB)

[Allyson_Smith]

Challenge13_Transform_Your_Data!.xlsx (539.3 KB)

[Presleigh_Thomas]

Here is my solution! I did some of the formulas different than the video but got the same answers. It’s cool that you can get the same answers using several different formulas.

[Starlee_Isom]

This was a great refresher on a lot of the Excel formulas I had forgotten some of the arguments for!

Solved_Challenge13_Transform_Your_Data!.xlsx (492.5 KB)

[Quinn_Askey]

Here is my solution! Cool how are there are so many different ways to get the correct answer.

[Daniel_Taylor]

This was a super fun challenge. We just reviewed these formulas in class this week, so I was excited to see that there was a challenge where we are able to put what we learned into practice. The hardest part for me was figuring out the hire date, but it was fun to finally figure out a solution. I was able to build off what I did in the ‘Hire Month’ section to figure out what to do in the ‘Hire Date’ section. Thanks for putting this challenge together.

[Daniel_Taylor]

Really cool on how you decided to do ‘Hire Month’ and ‘Hire Date.’ I did it differently, so it was cool to see another way to think about the solution.

[Dillon_Atkinson]

Challenge13_Transform_Your_Data!1.0.xlsx (544.2 KB)

A fun challenge!

[Nickolas_Hill]

Nick Hill_Challenge13_Transform_Your_Data!.xlsx (539.7 KB)

Great to use these New formulas of =TEXTBEFORE and =TEXTAFTER to make things simpler and to get the same answer! Thanks for the challenge and the experience in using these functions!

[Parker_Reynolds1]

Here are the formulas that I used, I had tried this one before I knew how to use the TextBefore and TextAfter formulas, but it was definitely a lot easier and faster being able to do it this way.

[Juliette_Sorensen]

[Sabrina_Gooch]

I had fun nesting the textbefore and textafter functions. Thanks!

[Ramya_Ramesh]

This is my solution to this problem! this was a fun problem to try and get creative with. I struggled to get my Birth Year to match the same format as the date but other than that I was able to figure out everything else.

Challenge13_Transform_Your_Data!.xlsx (214.0 KB)

[Ramya_Ramesh]

I like how you used the YEAR FUNCTION to match the format of the date. Love this!

[Avijay]

AG_Challenge13_Transform_Your_Data!.xlsx (545.1 KB)

[Tiffany_Hansen]

Text manipulation is so fun! It’s awesome to practice the skills that I have learned through Excel. I had to remind myself on how to apply the formula to all the cells instead of clicking and dragging to make the formula to the bottom of the dataset. I liked using the LEFT, RIGHT, and REPLACE functions as well as some other ones. Check out my solution below (I removed the = sign so the solution was visible)!

[Nathan_Strong]

0604_Challenge13_Transform_Your_Data!_Strong.xlsx (543.1 KB)
Interesting task! It reminded me of the importance of data types and conversions (I was running into issues at first with the “date” data type). I was able to use len(), right(), left() and find() functions.