This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
See attached my solution to challenge #2
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?
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?
Completed challenge 2
My solution is slightly different from the provided solution (I used the datetime tool).
I am attaching my solution.
Sharath Kumar Gurram.
Challenge #2 - Done!