The other method to put a line through your text in Word is as follows ... select Customize the Ribbon from the menu. The Excel Options dialog box will open. On the left, select All Commands ...

Let's face it—if you're automating your data workflow with formulas, you shouldn’t be manually rewriting text just to change ...

The easiest way to capitalize text in Excel is by using the PROPER function. It capitalizes the first letter of each word in a text string while converting all other letters to lowercase.