In the process of working with Excel, there will be times when you need to convert lowercase letters to all uppercase letters, or convert from uppercase letters to lowercase letters, you can use Unikey.
Unikey is a tool to support Vietnamese typing popular with users, especially when you work with office software Word, Excel, .. Besides helping you type Vietnamese, Unikey also owns some Other useful features such as transcoding fonts, converting accented text to unsigned or converting from lowercase to uppercase or vice versa that the Network Administrator will introduce to readers in this article.
The usual way to convert between lowercase and uppercase letters in Excel is to use the Upper function or the Lower function. However, some users experience a font error, or the text is not completely converted when using the function. The accented vowels will not normally be converted, affecting the content Excel is working on. So we can use Unikey to convert lowercase to uppercase and vice versa on Excel.
Video tutorial to change lowercase to uppercase in Excel
How to use Unikey to change uppercase to lowercase Excel
We will take the example with the table below. The letters in the table are not being styled together, and you will convert all letters to uppercase.
Step 1:
First of all, we highlight the entire data area we want to convert from lowercase to uppercase and then right-click choose Copy.
Step 2:
You right-click on the Unikey icon in the system tray and then select Tools…
Step 3:
The Unikey Toolkit dialog interface appears. Here section Code Table section Source choose Unicodepart Destination also choose Unicode. Next you will tick the option To uppercase in the Selection section.
Finally you click Transcoding then click on Close. The conversion will take place shortly thereafter.
Step 4:
Finally you will switch to a new Sheet in Excel and then right-click choose Paste.
When the message shown below appears, press OK to change to uppercase.
All Excel content in lowercase will be converted to uppercase as shown below. Letters will be completely converted to uppercase, without the vowel remaining in lowercase.
However, the font and table formats will all be deleted, so you will have to reformat.
Step 5:
In case you want to convert all from uppercase to lowercase, you just need to select To normal printing as shown below is ok. The remaining steps are the same as when converting from lowercase to uppercase.
Above is how to convert from lowercase to uppercase and vice versa using Unikey without font error. When using Unikey, the letters will be evenly converted to uppercase without error for some accented vowels.
Wishing you success!
Source link: How to convert uppercase to lowercase on Excel with Unikey
– https://techtipsnreview.com/