This tutorial explains how to change the upper or lower case settings of text in Excel using the XLSTAT software.
An Excel sheet with both the data and the results can be downloaded by clicking on the button below:
Download the data
The data set includes two ordinal categorical variables representing the responses to a survey (see below). Our goal is to capitalize the first letter of the first word.
Setting up the Lower and upper case dialog box in XLSTAT
Select the Lower and upper case feature under the Text Mining XLSTAT menu.
The Lower and upper case dialog box appears.
In the General tab, select columns A and B in the Data field. Check both options under the Lower case field in order to covert to upper cases the first letter of only the first word.