This will quickly copy the formula down the column. To capitalize the first letter of every word in a string in Excel, you may use the PROPER function. To capitalize only the first letter leaving ...