Separating first and last names in an Excel spreadsheet is a common task that can be time-consuming if done manually.

However, if you need to capitalize only the first letter and keep the rest unchanged, neither the PROPER function nor any other single Excel function can do that. To capitalize the first letter of ...

There are many formulas to add a comma after the first word in a cell. In case you have a list arranged across a column, you can replicate the formula across the list using the Fill option.