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?