PROPER(A2) IT converts the string on the cell A2 into sentence case i.e every first letter is capital SUBSTITUTE(A2,"_"," ") It substitutes 'space' in place of 'underscore' in A2 cell e.g i_am_amazing will be converted to i am amazing