The above formula will capitalize the first letter of the text string which is in cell C2 and convert the rest into lowercase. Here’s how: LOWER(C2) converts the entire text in cell C2 to lowercase.

Press the Enter key. Excel will split the text string on the basis of space ( ) delimiter. The output array will hold the following 3 values: ‘The’, ‘Windows’, and ‘Club’.

Microsoft Excel’s new text functions make working with strings a breeze. Find out how to use TEXTAFTER() and TEXTBEFORE() in this tutorial.