Challenge #2: Preparing Delimited Data

[DataGuy_V2]

First solution is attached. Have a great day!

Summary:

Spoiler

Formula > Replace Char (using double quotes to specify single quotes and vice-versa)
Text-to-columns
Date Conversion
Select appropriate fields

[Timi8]

My Solution

[Oren_Soloman]

Challenge Submission

[matada]

Solution

[AliAS2020]

Hello all,

This is an update to my previous solution, in this one I used 3 methods to practice as much tools as possible as you can see in the attached image and yxzp.

Using a mix of Text to Column, RegEx and Formula tools.

Spoiler

[jiteshthegenius]

SPOILER

[dpatnaik97]

Attached the solution for challenge 2.

[AnnaMikhaylova]

That was fun!

[sayooj]

hi

[try4dipen]

Here is my version of solution.