Your data analysis solution

Convert text data to lower or upper case in Excel

2019-03-21

This tutorial explains how to change the upper or lower case settings of text in Excel using the XLSTAT software.

Dataset

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. 

Output

Once you have clicked on the OK button, the output is displayed into a new sheet. All letters of the first words are now capitalized. 

1c26995d494fb3061dd0ae8571ffc0a4@xlstat.desk-mail.com
https://cdn.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/portal/articles/autocomplete
9283