REPLACE(LOWER(C2),1,1,UPPER(LEFT(C2,1))) takes the lowercase text from step 1 and replaces the first character (1st position, 1 character long) with the uppercase letter from step 3.

Create a batch file script that you can call from the CMD command line that will change lowercase characters to uppercase in an instant. Click the "Start" button and type "cmd" in the search box.

$2, $1 tells Excel that I want to reverse the order of those two strings of text, separated by a comma and a space. If I didn't include the dollar symbols, Excel would simply return "2, 1" as the ...

You often need to change the case of your text, e.g., switch from a text written in uppercase to lowercase and vice-versa, all without having to retype the entire text. In this article, we'll provide ...

F7 opens the spell checker in Excel, Word, Outlook, ... Shift-F3 toggles the case of the selected text (in Outlook as well), rotating from sentence case to uppercase to lowercase and so on.