Hi the whole house, office work with Excel certainly makes you tired of switching between: lowercase, Chinese, IN. It's impossible to manually correct a data list if it's too much. Using formulas to transfer is too trivial and also takes time to manipulate. Hieu encountered this case, also learn, then know Excel does not support text conversion shortcuts.
After this article, we can set shortcuts to convert lowercase letters to capital letters, printed letters in Excel. Hieu will guide the fastest way, much simpler than online articles.
Download an Excel text converter file
First you download the PERSONAL file. XLSB
We use VBA in Excel to install the type change shortcut. This file is composed by Hieu after groping with VBA code. So you don't have to spend your time researching it.
Add lowercase to capital and print shortcuts in Excel
You copy the PERSONAL file. XLSB enters drive C in a path
If you can't find the AppData folder, it's hidden. You turn it on by clicking the Organize button on the left corner and selecting Folder and search options. Next on the View tab, click show hidden files, folders and drivers > OK.
You can watch the clip if you find it difficult.
Use keyboard shortcuts to switch lowercase, Chinese, IN
You open a new Excel file to try. Select the cell to switch text to and use the following keyboard shortcuts:
Ctrl J: converted to print (MINH HIEU)
Ctrl M: converted to initial capital (Minh Hieu)
Ctrl Q: converted to lowercase (filial)
With the new Excel file, it's definitely a success. As for old Excel files that are normal, only some files may not work if it has ever been tweaked something in the VBA. It can be overcome but a little confusing so Hieu does not say in this article.
Thanks to this way, the work with importing data into Excel of Hieu significantly improved, you should try and comment the results below to hieu know.