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.
My version with Regex.
The 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.
Thank you @neilgallen for the easily understandable solution.
Here's my solution.
My solution attached
Got that one tool solution, but holy nested REGEX batman...
edit: just looked at some other solutions and I really overcomplicated this...