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’.

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.

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

You can add alt text descriptions in Excel to any kind of illustration, including photos, screenshots, shapes, 3D models, and Smart Art.