Calculating ratio with Microsoft Excel formula

University of Mumbai has asked for conversion of marks in a peculiar way for the exams conducted online during this academic year. Following video explains how to convert marks obtained by the students according to the University formula. This was a popular post among the teaching community and students and got more than 4k views.

Joining text from two columns, removing unwanted spaces in a text string and using function googletranslate()