Merge Last Name and First Name columns in Excel without losing content

Buzz

Ngày cập nhật gần nhất: 15/4/2026

Content

Merge Last Name and First Name columns in Excel without losing content

Method 1: Using the CONCATENATE string function

Method 2: Using the & operator to concatenate cells

With the standard method of merging cells in Excel, when merging two or more cells with content, you often have to choose between the content of one of them. So, how can you merge both without losing any data? With the Concatenate function, this can be easily achieved. Follow the article Merge Last Name and First Name columns in Excel without losing content for details.

Tính năng gộp ô Merge Cell trong Excel không thể giúp chúng ta gộp ô đều chứa nội dung bên trong. Tuy nhiên chúng ta có thể sử dụng hàm chức năng để gộp các ô này lại hoặc có thể sử dụng toán tử "&" cũng mang lại kết quả tương tự. Trong bài viết dưới đây, Mytour sẽ thực hiện một ví dụ gộp 2 cột Họ và Tên trong Excel không mất nội dung bằng việc sử dụng hàm ConcateNate để tạo thành tên hoàn chỉnh.

Merge Last Name and First Name columns in Excel without losing content

We have a data table below consisting of columns Last Name, First Name, Full Name. We will merge columns Last Name and First Name to get Full Name.

Method 1: Using the CONCATENATE string function

The CONCATENATE function concatenates 2 or more strings into one string.
Syntax: CONCATENATE(text1,text2,...)

Where

- Text1: Mandatory. The first item to concatenate, can be text, number, or numerical reference
- Text2,...: Optional. Additional text items to concatenate. Maximum 255 items, 8192 characters

Enter the formula =CONCATENATE(B5,' ',C5) into cell D5, then press Enter to check the result

Drag down to copy the formula and complete the cells below.

Method 2: Using the & operator to concatenate cells

This method is much simpler than using the Concatenate function because you won't need to remember complex function and formula syntax.

Enter the formula =B5&' '&C5 into cell D5, then press Enter to check the result

Drag down to copy the formula and complete the cells below.

Here are 2 methods to merge the Last Name and First Name columns in Excel without losing content. Hopefully, with this article, you have learned how to merge cells without losing content in any cell. Moreover, if you are proficient in Excel shortcuts, you will use this tool better. If not clear, you can also refer to more Excel shortcut articles to perform editing operations in Excel more quickly.

Frequently Asked Questions

What are the steps to merge last and first name columns in Excel without losing data?

To merge last and first name columns without losing data, you can use the CONCATENATE function or the '&' operator. For CONCATENATE, use the formula =CONCATENATE(B5,' ',C5). Alternatively, with the '&' operator, use =B5&' '&C5. Drag down to apply to other cells.

Can the CONCATENATE function in Excel combine more than two strings?

Yes, the CONCATENATE function can combine up to 255 strings, allowing you to merge multiple cells into one. Simply list the cells you want to concatenate in the function: =CONCATENATE(text1, text2, ...).

Is using the '&' operator easier than using the CONCATENATE function in Excel?

Yes, using the '&' operator is generally easier and requires less syntax than the CONCATENATE function. You simply type =B5&' '&C5 to combine values, making it quicker for users.

What should I do if I want to merge cells in Excel without losing any content?

To merge cells without losing content in Excel, use either the CONCATENATE function or the '&' operator. Both methods allow you to join text from multiple cells effectively without losing any information.

Mytour's content is for customer care and travel encouragement only, and we are not responsible.

For errors or inappropriate content, please contact us at: [email protected]