Challenge #2: Preparing Delimited Data

[tcroberts]

Here's my solution

Spoiler

[AGoyal]

Solution

Spoiler

[mizard]

I used the text to columns, formula and date conversation tools to get to the solution.

[KMiller]

Solution attached

[MattKing]

Hi, here is my solution

[OldDogNewTricks]

I just received my license last week and I spent some time over the weekend on these challenges.  I completed 11 challenges Friday and Saturday night (hey, my wife is out of town OK!).

Here is my solution to this problem.

[gmartin]

Here is my solution!

Spoiler

[Aadrika]

Here's my solution!

[mdgajes1]

After seeing the solution, using the Formula tool to convert the date probably is simpler. I went with the DateTime tool.

[dharini]

Here is my solution.