vnTools is a great support tool in working with Excel. With a variety of functions, suitable for users in Vietnam, helps you convert lowercase, capital letters, fonts, fonts or change numbers into letters. This is an indispensable tool in your computer.
You can download the latest vnTools tool here: vnTools
Instructions to convert upper and lower case, each word in Excel using vnTools
In this article, I will introduce you to the font conversion function of vnTools.
How to switch lowercase, uppercase the first sentence, each word in Excel using vnTools
To convert fonts to vnTools, open the Excel file to be converted, and then follow the steps below.
Step 1: Select the data area you want to convert, open the tab vnTools, click Change Font Style.
Using vnTools, convert lowercase letters to uppercase letters in Excel
Step 2: In a new window XL Change Case There are 4 conversion options for you, including:
+ The word “uppercase”
+ The “lowercase” word
+ The word “Capital At The Beginning Of Each Word”
+ The word “capitalization”
Step 3: Choose a font style to convert.
Option 1: Choose to switch to “LETTERS”
If you want to put all the fonts in the selected data area into uppercase, you choose Capital” then press OK, got it.
The result will be as shown below.
Option 2: Choose to switch to “lowercase”
To switch the entire case in the selected data area to lowercase, select “Lower case”, finished press OK, got it.
Using vnTools, convert uppercase letters to lowercase letters in Excel
We get the result:
Option 3: Choose to switch to “Capital At The Beginning Of Each Word”
Want to print capital at the beginning of each word, you choose The “Flowers At The Beginning Of Each Word” then press OK, got it.
Option 4: Choose to switch to “Capital at the beginning of sentences”
You choose “Flowers at the beginning of sentences” then press OK, got it.
So I have instructed you to complete how to convert lowercase, capitalize each sentence, each word in Excel as well as options to convert uppercase, lowercase, capitalize each word, capitalize each sentence by using vnTools. In this article I use Excel 2007, but you can also apply the same way with other versions of Excel.
In addition to the font conversion function, vnTool also helps you convert Unicode, VNI, TCVN 3 fonts, or help convert numbers into letters (Vietnamese or English). This tool is quite useful for jobs related to revenue and expenditure, payroll, currency, so please take advantage of all features of vnTools to best serve your work.