How to Merge First Name with Surname in Microsoft Excel

Let’s say you want to create a single Full Name column by combining two other columns, First Name and Last Name. To combine first and last names, use the CONCATENATE function or the ampersand (&) operator.

Merging First Name and Last Names using the CONCATENATE function or the ampersand (&) operator. These two ways help to join first and last names easily. CONCATENATE is a text function that join two or more text string into one string.

Please take the opportunity to connect and share this video with your friends and family if you find it useful.