Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEANice, I immediately went macro but could have been simpler, also couldn't really be bothered to faff with the column order but note others' solutions and persistence to do so!
For some reason it had never crossed my mind that you could update a string formula like that until I just tried it!
Here's my solution. The standard macro contains similar tools.