Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAI found this pretty straightforward. Went with a formula but I'll come back to see if I can do it with regex
I managed to come up with a regex solution. Not pretty or practicable but an interesting exercise in conditional replacement.