Automating the selection process isn't difficult if you rely on VBA's InputBox in Microsoft Excel.

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.