Buzz
Diverging from the enchantments of Microsoft Word, Microsoft Excel lacks the wizardry to alter characters, transitioning them from uppercase to lowercase. Nevertheless, fear not, for the spellbinding 'Lower' function in Excel can seamlessly and swiftly execute this transformation. Let's embark on this mystical journey with SoftwareMagic.vn.
Method 1: Changing Uppercase to Lowercase in Excel with the Lower Function.
Step 1: In the adjacent cell D2, enter the formula =LOWER(B2). See the screenshot below:
Step 2: Press Enter, and the formula is applied to cell D2. Then select D2, choose the range of cells where you want to apply this formula. All uppercase text strings will magically transform into lowercase. See the screenshot for a glimpse.
Method 2: Use Unikey to Convert Uppercase to Lowercase
Step 1: Highlight the entire text you want to convert from uppercase to lowercase using the shortcut Ctrl + A, then right-click and choose Copy, or use Ctrl+C on the keyboard.
Step 2: Right-click on the Unikey icon in the toolbar and click Tools...[Ctrl+C] or press the shortcut Ctrl+Shift+F6.
Step 3: When the Unikey Toolkit window appears, check 'Convert to lowercase,' then click 'Switch encoding' as illustrated below.
Note: Ensure the source is set to TCVN3(ABC) and the destination to Unicode.
Step 4: The program will display the message 'Successfully converted RTF clipboard'. Click OK to close it.
Step 5: Return to the Excel file you want to transform, right-click, and choose Paste (Ctrl+V) to insert the text. You will see the result as depicted below.
Finally, you've succeeded in converting uppercase to lowercase using Unikey.
With just a few clever Excel tricks, you've effortlessly transformed uppercase to lowercase. Wishing you success with the LOWER() function and using Unikey for converting from uppercase to lowercase.
