Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAFormula tool for every solution.
Bit confused as many replies seem to be different from the start file on the header. But anyways here is mine.
I used Regex on the second part, did not know I could just use 'ToNumber' and it would remove the text altogether. My Excel brain presumed that would throw an error. Good to know!