Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAThank you
Thank you
Might try it again with regex
Fun challenge!
Question: After the use of the RegEx Tool (never used before) the first column separated into 2 columns. But I see how the 2 new columns changed names.
But in the 2nd row I'm not understanding where the $7.36 is coming from. Many other I see it was part of the 1st column description, but not in row 2. I noticed this in other rows, but I thought I would just start with 2nd row.
Any help on this will be greatly appreciated.
Here is my solution:
Went for a golf based approach
Tried to do as much in the formula tool as possible