Google interview question

String manipulation problem that you have to solve to a google sheet.