Challenge #2: Preparing Delimited Data

[arvinang]

Thanks for the challenge. Attached is my solution which gives similar result

[Fer_R]

Getting ready for the product certification. Thanks for the challenge!

Solution is attached. 

[_tbrown]

Done

[danuliatko]

My submission

[kmcdaniel]

This probably isn't the most elegant of solutions, but it worked. 

I used the text to columns and DateTime tools.

[KT2]

Spoiler

Spoiler

Boom.

[NicoleNwoha]

Here's my solution. Thanks for the challenge!

[timrains]

Nice challenge. 

Spolier: 

Spoiler

text to columns to split out field1, then two replace formulas to strip the " and ' ...

[varunvarma87]

Challenge 2 completed !

Spoiler

[Jackbrob]

Was fun 🙂