Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAThe University class on RegEx to the rescue!
I can't seem to even interpret the RegEx of the one tool solutions. Just something about capture groups and juggling them around. So if anyone has a helpful read on that for me, thanks in advance.
Here's my multi-tool approach:
I knew the one tool solution was a RegEx Replace formula but I couldn't quite get the syntax right.
My solution:
Thank you @neilgallen for the easily understandable solution.
Got that one tool solution, but holy nested REGEX batman...
edit: just looked at some other solutions and I really overcomplicated this...