Challenge #2: Preparing Delimited Data

[michael_apau]

[Antoinette]

[katestrohm]

1. Text to columns

2. StripQuotes formula to remove quotes in columns 1 and 3

3. DateTime tool to convert string data to a date

4. Select tool to rename and remove columns

[mindyzhang99]

My Solution

1) Use the Delimiters of , " ' to split the Field_1 column to 7 columns

2) Use the DateTime to convert string into date

3) Select the columns you need and rename them

[asimmonz9076]

Done.

[aniselyasi]

[Abie]

Done

[sylwia-rej]

My solution:

Spoiler

[yuval]

my solution 

[silvia_srb]

My solution