Challenge #2: Preparing Delimited Data

[gcarroll]

See attached my solution to challenge #2

[fabriciopsouza]

Spoiler

[fabriciopsouza]

Spoiler

[WH]

Hi,

I am using 2 text-to-column tools to split by both single quote and double quote, any one can kindly share why splitting by ' and " cannot be done with a single text-to-column tool?

Thanks.

[Owain_Perry]

I've attached my solution. I was a bit confused in the main solution to the inclusion of the formula's as I didn't think they would be beginner. Where would be the best place to learn about these?

[MichaelEvans]

Completed 

[MichaelEvans]

Completed challenge 2 

[Verenala4]

Hi,

My solution is slightly different from the provided solution (I used the datetime tool).

Spoiler

V

[sharathkumargurram1]

Hi ,

I am attaching my solution.

Best Regards,

Sharath Kumar Gurram.

[Thableaus]

Challenge #2 - Done!

Spoiler

Cheers,