Combine First And Last Names. Once you are happy with your selection click combine names. Most states require a court order to merge two last names.

Type CONCATENATE XX YY into the cell. 1 B3 C3. Heres how you can use Flash Fill to combine first and last names.
Type CONCATENATE XX YY into the cell.
Try creating new column and in the DAX bar type. 2 select CONCATFirstName MiddleName Last. First and last name is not null field but middle name is nullable field. This is a quick tutorial on how to combine first name and last name in Excel.