topic Display String into excel from program as mentioned below... in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/display-string-into-excel-from-program-as-mentioned-below/m-p/7937403#M1600342 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am downloading excel from report program.</P><P></P><P></P><P></P><P>I can convert string to either uppercase or lowercase,but i need to convert the string like this as shown below,,,,</P><P></P><P></P><P></P><P>'SUBRHMANYAM' conver this name into </P><P></P><P>'Subrahmanyam'.</P><P></P><P>The first letter should be capital.</P></BODY></HTML> Thu, 02 Jun 2011 05:08:16 GMT Former Member 2011-06-02T05:08:16Z Display String into excel from program as mentioned below... https://community.sap.com/t5/application-development-and-automation-discussions/display-string-into-excel-from-program-as-mentioned-below/m-p/7937403#M1600342 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am downloading excel from report program.</P><P></P><P></P><P></P><P>I can convert string to either uppercase or lowercase,but i need to convert the string like this as shown below,,,,</P><P></P><P></P><P></P><P>'SUBRHMANYAM' conver this name into </P><P></P><P>'Subrahmanyam'.</P><P></P><P>The first letter should be capital.</P></BODY></HTML> Thu, 02 Jun 2011 05:08:16 GMT https://community.sap.com/t5/application-development-and-automation-discussions/display-string-into-excel-from-program-as-mentioned-below/m-p/7937403#M1600342 Former Member 2011-06-02T05:08:16Z Re: Display String into excel from program as mentioned below... https://community.sap.com/t5/application-development-and-automation-discussions/display-string-into-excel-from-program-as-mentioned-below/m-p/7937404#M1600343 <HTML><HEAD></HEAD><BODY><P>You can use FUNCTION : 'ISP_CONVERT_FIRSTCHARS_TOUPPER'</P></BODY></HTML> Thu, 02 Jun 2011 05:25:48 GMT https://community.sap.com/t5/application-development-and-automation-discussions/display-string-into-excel-from-program-as-mentioned-below/m-p/7937404#M1600343 Former Member 2011-06-02T05:25:48Z Re: Display String into excel from program as mentioned below... https://community.sap.com/t5/application-development-and-automation-discussions/display-string-into-excel-from-program-as-mentioned-below/m-p/7937405#M1600344 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>You can try this.</P><P></P><P>va_text = 'subrahmanyam'.</P><P>TRANSLATE va_text+0(1) TO UPPER CASE.</P></BODY></HTML> Thu, 02 Jun 2011 06:08:38 GMT https://community.sap.com/t5/application-development-and-automation-discussions/display-string-into-excel-from-program-as-mentioned-below/m-p/7937405#M1600344 Former Member 2011-06-02T06:08:38Z