Excel's built-in functions can be used to solve the problem of unformatted Names and Addresses. The function we will use to solve this problem is the Proper function. It automatically capitalizes the first character in a name or address or any string.