Replace formulas with values and delete the original columns You can also capitalize the first letter in each cell as explained in the above-linked article. An easy fix is using the PROPER function that forces the first character in each word to uppercase and the rest to lowercase: If you are working with a personnel roster created by someone else, and that someone is not a very accurate person, some of the names may be written in lowercase and others in uppercase letters. To eliminate excessive spaces between words to one space character, wrap each cell reference into the TRIM function, and then concatenate. As the result, extra spaces may appear between the merged names like in the left-hand table below. In case your information is coming from an external database, chances are that the original columns have some trailing spaces invisible to the human eye, but perfectly read by Excel.

But if, against all expectations, your formula works imperfectly or does not work at all, the following tips may help you get on the right track. Tips and notes on combining names in ExcelĪs you have just seen, it's very easy to merge first name and last name in Excel with a formula. Initial + Surname in lowercase without a space Initial + Surname separated by a period and a space Merge the initial with the last name without a space:Ĭombine the initial and last name, and convert the combined name to lowercase:įor your convenience, the following table shows all the formulas along with their results: With the first name in A2 and the last name in B2, the formula takes the following shape:ĭepending on the desired result, one of the following variations of the above formula may come in handy. Generally, you use the LEFT function to extract the first letter of the forename, and then concatenate it with the surname separated by a space character. This example shows how to combine two names into one in Excel and convert a full name into a short name.

In Excel 2016 - 365, you can also use the CONCAT function to combine names.

Download kingsfield 5