Buzz
vnTools is an excellent support tool for Excel tasks. Tailored for users in Vietnam, it enables easy conversion to lowercase, capitalization of the first letter of each sentence, font styling, and changing numbers to words. This tool is a must-have for your computer.
Exploring vnTools Font Conversion Function in This Article
How to Change Case, Capitalize, and Format Words in Excel Using vnTools
To switch fonts with vnTools, open the Excel file you want to modify and follow the steps below.
Step 1: Select the data range you wish to modify, go to the vnTools tab, and click on Convert Font Style.
Using vnTools to Convert Lowercase to Uppercase in Excel
Step 2: In the new XL Change Case window, there are 4 conversion options for you, including:
+ Uppercase
+ Lowercase
+ Capitalize Each Word
+ Sentence case
Step 3: Select the font style for conversion.
Choose Option 1: Select to convert to 'UPPERCASE' text.
If you wish to transform all text within the selected data range to uppercase, click on 'UPPERCASE' and then press OK.
The result will appear as shown below.
Choose Option 2: Select to convert to 'lowercase' text.
To convert all text within the selected data range to lowercase, choose 'Lowercase', then click OK.
Utilize vnTools to transform uppercase to lowercase in Excel.
The outcome is as follows:
Choose Option 3: Select to convert to 'Title Case' text.
To capitalize the first letter of each word, select 'Title Case', then press OK.
Outcome:
Choose Option 4: Select to convert to 'Sentence Case' text.
Select 'Sentence Case' and press OK.
Final Outcome:
So, I've successfully guided you on how to switch between lowercase and uppercase in Excel. This includes options for converting to lowercase, uppercase, capitalizing the first letter of each word, and capitalizing the first letter of each sentence using vnTools. In this article, I demonstrated using Excel 2007, but you can apply the same method to other versions of Excel as well.
In addition to text transformation functions, vnTools also assists in switching between Unicode, VNI, TCVN 3 font types, or converting numbers to words (in Vietnamese or English). This tool proves quite handy for tasks related to financial calculations, payroll, currency, so make the most of vnTools' features to enhance your productivity.
