How to convert uppercase to lowercase on Excel with Unikey

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.

Data table on Excel

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.

Copy the content to be transferred

Step 2:

You right-click on the Unikey icon in the system tray and then select Tools…

See more:  How to Set Up a Recovery Key and Two-Step Authentication in Firefox

Tools on Excel

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.

Convert code on Unikey

Step 4:

Finally you will switch to a new Sheet in Excel and then right-click choose Paste.

Paste the transferred content

When the message shown below appears, press OK to change to uppercase.

Notice on Excel

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.

Lowercase letters to uppercase

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.

Convert uppercase letters to lowercase

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/

, , , ,

Leave a Reply

Your email address will not be published. Required fields are marked *