Say you have value raheel syed in cell E.g A1=raheel syed and your requirement is to have single quote before and after with comma as for E.g ‘raheel syed’, so how do you do it ? Use this formula in MS-excel
In cell A1=raheel syed then in adjacent cell use formula =”‘”&A1&”‘,” now the new value would be ‘raheel syed’,
If you need the value in UPPERCASE , use =UPPER(“‘”&A1&”‘,”) the new value would be ‘RAHEEL SYED’,
Hope this helps !!