Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

finished Challenge #2

Completed.

Challenge 2 Completed

My solution

Solved it.

Have attached:

my solution

Done

i used text to columns and formulas as well as convert date/time

I approached this as follows:

I used a formula to remove the quotes, and used the select tool to remove and rename data fields

Thanks

Debs

Challenge #2: Preparing Delimited Data