Have you ever tried to drag the header columns in an Excel spreadsheet to make them fit the text? I have and just when I think I’ve got it right, a quick glimpse down the line of columns usually ...

To capitalize the first letter of a text string in Excel, you can use a formula that combines multiple functions. We show you how to do it.