# 13|EXCEL – Transform Your Data! **URL:** \ **Category:** Challenges\ **Tags:** excel, beginner, managerial, etl\ **Created:** [February 17, 2023, 3:05pm UTC](https://www.techhub.training/t/13-excel-transform-your-data/163 "2023-02-17T15:05:23Z")\ **Posts on this page:** 20\ **Page:** 2
**Author:** ![Caden\_Vandygriff](https://avatars.discourse-cdn.com/v4/letter/c/9e8a1a/32.png) [@Caden\_Vandygriff](https://www.techhub.training/u/Caden_Vandygriff)\ **Post date:** [September 15, 2023, 8:07pm UTC](https://www.techhub.training/t/13-excel-transform-your-data/163/21 "2023-09-15T20:07:46Z")
[Challenge13\_Transform\_Your\_Data! (1).xlsx](https://www.techhub.training/uploads/short-url/9ctxRcRnuDDXV4MwPQqPmqouOsI.xlsx) (546.5 KB) ---
**Author:** ![Zachary\_Marsden](https://avatars.discourse-cdn.com/v4/letter/z/d2c977/32.png) [@Zachary\_Marsden](https://www.techhub.training/u/Zachary_Marsden)\ **Post date:** [September 15, 2023, 9:42pm UTC](https://www.techhub.training/t/13-excel-transform-your-data/163/22 "2023-09-15T21:42:36Z")
[Challenge13\_Transform\_Your\_Data!.xlsx](https://www.techhub.training/uploads/short-url/A9Nq270R5HRtsdU4wybY8ahRXQd.xlsx) (542.6 KB) ---
**Author:** ![Molly\_Baird](https://avatars.discourse-cdn.com/v4/letter/m/f19dbf/32.png) [@Molly\_Baird](https://www.techhub.training/u/Molly_Baird)\ **Post date:** [September 16, 2023, 3:22am UTC](https://www.techhub.training/t/13-excel-transform-your-data/163/23 "2023-09-16T03:22:58Z")
This challenge was a great reminder of the text manipulation functions, many of which I had completely forgotten how to use. My solutions were a bit different than the video provided, but that’s the fun thing about Excel there are many ways to get the correct answer. [Challenge13\_Transform\_Your\_Data!.xlsx](https://www.techhub.training/uploads/short-url/uhjSCpJU4lZZAM72gYqVo459KGj.xlsx) (643.9 KB) ---
**Author:** ![Masahiro\_Hokazono](https://avatars.discourse-cdn.com/v4/letter/m/b5a626/32.png) [@Masahiro\_Hokazono](https://www.techhub.training/u/Masahiro_Hokazono)\ **Post date:** [September 16, 2023, 4:31am UTC](https://www.techhub.training/t/13-excel-transform-your-data/163/24 "2023-09-16T04:31:21Z")
Although it was my first time and pretty confusing, I think It was great to do text manipulation functions in Excel. I was able to understand how powerful the formulas are used in this problem, and I hope to use them in the future. ![Screenshot 2023-09-15 at 10.14.36 PM](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/1X/22459ea5ca2f2ddda412f4cf2e6b521db8a427e7.jpeg) ---
**Author:** ![Robert\_Flores](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/robert_flores/32/1501_2.png) [@Robert\_Flores](https://www.techhub.training/u/Robert_Flores)\ **Post date:** [September 16, 2023, 4:47am UTC](https://www.techhub.training/t/13-excel-transform-your-data/163/25 "2023-09-16T04:47:09Z")
![Data transformation 1](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/1X/b665c97439af405b3fbd8ec2d226ee287e665e8c.jpeg) ---
**Author:** ![Robert\_Flores](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/robert_flores/32/1501_2.png) [@Robert\_Flores](https://www.techhub.training/u/Robert_Flores)\ **Post date:** [September 16, 2023, 4:48am UTC](https://www.techhub.training/t/13-excel-transform-your-data/163/26 "2023-09-16T04:48:51Z")
The data extraction was pretty straightforward except for SSN. I had some trouble inserting the two functions in conjunction. I know a replace function needs to be added. What is the thought process there? ---
**Author:** ![Lindsay\_North](https://avatars.discourse-cdn.com/v4/letter/l/d2c977/32.png) [@Lindsay\_North](https://www.techhub.training/u/Lindsay_North)\ **Post date:** [September 16, 2023, 3:17pm UTC](https://www.techhub.training/t/13-excel-transform-your-data/163/27 "2023-09-16T15:17:04Z")
[Challenge13\_Transform\_Your\_Data!.xlsx](https://www.techhub.training/uploads/short-url/7Raajph1XN3h3PNyvlLXGnlzKiE.xlsx) (578.3 KB) This was a great refresh of how to do text manipulations in excel. ---
**Author:** ![Rachel\_Gill](https://avatars.discourse-cdn.com/v4/letter/r/bbe5ce/32.png) [@Rachel\_Gill](https://www.techhub.training/u/Rachel_Gill)\ **Post date:** [September 16, 2023, 3:34pm UTC](https://www.techhub.training/t/13-excel-transform-your-data/163/28 "2023-09-16T15:34:10Z")
I learned a lot doing this challenge! ![excel challenge 13](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/1X/d5ae6dd3c9f8779ddd6e918d7b1a9a404ea87d79.png) ---
**Author:** ![Nick\_Roberts](https://avatars.discourse-cdn.com/v4/letter/n/c89c15/32.png) [@Nick\_Roberts](https://www.techhub.training/u/Nick_Roberts)\ **Post date:** [September 16, 2023, 4:47pm UTC](https://www.techhub.training/t/13-excel-transform-your-data/163/29 "2023-09-16T16:47:42Z")
Here is my solution [Challenge13.xlsx](https://www.techhub.training/uploads/short-url/cJ1Gi6OeGwncImPVvKg1NTt9nhu.xlsx) (540.9 KB) ---
**Author:** ![Ben\_Shaw](https://avatars.discourse-cdn.com/v4/letter/b/f475e1/32.png) [@Ben\_Shaw](https://www.techhub.training/u/Ben_Shaw)\ **Post date:** [September 16, 2023, 5:18pm UTC](https://www.techhub.training/t/13-excel-transform-your-data/163/30 "2023-09-16T17:18:44Z")
This was a great refresher on text manipulation. I probably used different formulas than most but was able to format everything. I had some trouble thinking through how to splice the hire dates into separate months, days, and years respectively but ultimately figured it out after some quick trial and error. Here are my solutions: [Ben\_Shaw\_Transform\_Your\_Data!.xlsx](https://www.techhub.training/uploads/short-url/v9Adfd0lHuMeduDIxL4Lc5I6OTh.xlsx) (538.7 KB) ---
**Author:** ![Amanda\_Yancey](https://avatars.discourse-cdn.com/v4/letter/a/ce7236/32.png) [@Amanda\_Yancey](https://www.techhub.training/u/Amanda_Yancey)\ **Post date:** [September 16, 2023, 7:55pm UTC](https://www.techhub.training/t/13-excel-transform-your-data/163/31 "2023-09-16T19:55:39Z")
[Challenge13\_Transform\_Your\_Data!.xlsx](https://www.techhub.training/uploads/short-url/noNvRbGPMqDK54Cp4Q1soLA53Vl.xlsx) (539.9 KB) Here is my solution! ---
**Author:** ![Megan\_Bassett](https://avatars.discourse-cdn.com/v4/letter/m/f08c70/32.png) [@Megan\_Bassett](https://www.techhub.training/u/Megan_Bassett)\ **Post date:** [September 16, 2023, 11:14pm UTC](https://www.techhub.training/t/13-excel-transform-your-data/163/32 "2023-09-16T23:14:46Z")
[Challenge13\_Transform\_Your\_Data!MB.xlsx](https://www.techhub.training/uploads/short-url/8csYz3wspbljJhxvVR9SiLrV1O4.xlsx) (546.0 KB) This was fun to solve! I like how there are a lot of different ways of getting to the answer. ---
**Author:** ![Halle\_Hawkins](https://avatars.discourse-cdn.com/v4/letter/h/ccd318/32.png) [@Halle\_Hawkins](https://www.techhub.training/u/Halle_Hawkins)\ **Post date:** [September 17, 2023, 1:56am UTC](https://www.techhub.training/t/13-excel-transform-your-data/163/33 "2023-09-17T01:56:07Z")
My solution! [9-16-23 Tech Hub HW 2 Challenge38\_Cowabunga\_Inventory (2).xlsx](https://www.techhub.training/uploads/short-url/lSohuMy1298vmRQcFdDjBHppsrN.xlsx) (16.1 KB) ---
**Author:** ![Samuel\_Allen](https://avatars.discourse-cdn.com/v4/letter/s/cc9497/32.png) [@Samuel\_Allen](https://www.techhub.training/u/Samuel_Allen)\ **Post date:** [September 17, 2023, 2:39am UTC](https://www.techhub.training/t/13-excel-transform-your-data/163/34 "2023-09-17T02:39:44Z")
![techhub training1](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/1/15cd71c777541cea8d81ea67f2124ea36664e493.png) Thanks for the video demonstrating the mid function! ---
**Author:** ![Jared\_Sanchez](https://avatars.discourse-cdn.com/v4/letter/j/4af34b/32.png) [@Jared\_Sanchez](https://www.techhub.training/u/Jared_Sanchez)\ **Post date:** [September 17, 2023, 3:52am UTC](https://www.techhub.training/t/13-excel-transform-your-data/163/35 "2023-09-17T03:52:28Z")
[Challenge13\_Transform\_Your\_Data!.xlsx](https://www.techhub.training/uploads/short-url/42VFWpzJTB2UJQsxtTsXEyfcAcs.xlsx) (413.6 KB) This is my solution. This solution took me a couple of tries and I had to use the built in tips that excel provides. There are different formulas that can be used to obtain the desired outcomes. In the end, I used a variety of methods to acquire practice. Great exercise! ---
**Author:** ![Nathan\_Farrell](https://avatars.discourse-cdn.com/v4/letter/n/f07891/32.png) [@Nathan\_Farrell](https://www.techhub.training/u/Nathan_Farrell)\ **Post date:** [September 17, 2023, 5:01am UTC](https://www.techhub.training/t/13-excel-transform-your-data/163/36 "2023-09-17T05:01:43Z")
![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/6/60e87dd1bc4ec217d1ff27b2ee92d541ec7e1b56.png) the video and the comments were very helpful in helping me complete this challenge ---
**Author:** ![Caleb\_McKay](https://avatars.discourse-cdn.com/v4/letter/c/858c86/32.png) [@Caleb\_McKay](https://www.techhub.training/u/Caleb_McKay)\ **Post date:** [September 17, 2023, 6:41am UTC](https://www.techhub.training/t/13-excel-transform-your-data/163/37 "2023-09-17T06:41:10Z")
I enjoyed this one. I found a new formula I had not used before with text manipulation. [Challenge13\_Transform\_Your\_Data!.xlsx](https://www.techhub.training/uploads/short-url/utz3gURSMG1it25Jy9AMFOI0w67.xlsx) (552.3 KB) ---
**Author:** ![Megan\_Arnold](https://avatars.discourse-cdn.com/v4/letter/m/e480ec/32.png) [@Megan\_Arnold](https://www.techhub.training/u/Megan_Arnold)\ **Post date:** [September 17, 2023, 4:02pm UTC](https://www.techhub.training/t/13-excel-transform-your-data/163/38 "2023-09-17T16:02:57Z")
Here is my solution to this problem! This challenge was great and really helped me remember some of the formulas that I have used previously. ![Screenshot 2023-09-17 100008](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/d/daf8aaf94c838298ee41c81d83c73b519b685253.png) ---
**Author:** ![Baiyi\_Chen](https://avatars.discourse-cdn.com/v4/letter/b/90db22/32.png) [@Baiyi\_Chen](https://www.techhub.training/u/Baiyi_Chen)\ **Post date:** [September 17, 2023, 7:28pm UTC](https://www.techhub.training/t/13-excel-transform-your-data/163/39 "2023-09-17T19:28:30Z")
Here is my solution [Challenge13\_Transform\_Your\_Data!.xlsx](https://www.techhub.training/uploads/short-url/zaYb3t9eU2IEEQVHQDYtCaHBIcv.xlsx) (496.5 KB) ---
**Author:** ![Jacob\_Farnsworth](https://avatars.discourse-cdn.com/v4/letter/j/e9a140/32.png) [@Jacob\_Farnsworth](https://www.techhub.training/u/Jacob_Farnsworth)\ **Post date:** [September 17, 2023, 8:24pm UTC](https://www.techhub.training/t/13-excel-transform-your-data/163/40 "2023-09-17T20:24:00Z")
![Screen Shot 2023-09-17 at 2.23.19 PM](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/0/03588c0cd5f87a9700b3cadcd5c958276fdc05f3.png) This was very difficult but it was a great refresher on some of the formulas I learned in the past. [Previous page](https://www.techhub.training/t/13-excel-transform-your-data/163.md?page=1) [Next page](https://www.techhub.training/t/13-excel-transform-your-data/163.md?page=3)