Buzz
Nowadays, using Excel for both study and work has become quite common. Do you know all the cool features of Excel? Today, I'll share one of the many awesome features of Excel: how to merge first name and last name columns in Excel on your computer super quickly and conveniently to help you better understand this feature.
1. Using formulas
To merge two columns in Excel, we can use formulas. The steps are as follows:
Step 1: Enter the formula =D5&' '&E5 (See example).
Step 2: Press Enter to get the result.
Step 3: Copy the formula to the following cells and you will get the final result.
2. Using CONCATENATE function
Apart from the first method, we can use the CONCATENATE function to merge. The steps are as follows:
Step 1: Enter the formula =CONCATENATE(D5,' ',E5) (See example).
Step 2: Press Enter to get the result.
Step 3: Copy the formula to the following cells and you will get the final result.
So there you have it, I've shared how to merge first name and last name columns in Excel super quickly and conveniently. Hope this article helps everyone out. If you find it helpful, feel free to share it with those in need.
You may not know this, but 100% of laptops from Mytour come with pre-installed genuine Windows (updated to Windows 11 by Microsoft). If you're looking to buy a laptop for studying, working, and experiencing the Microsoft 365 ecosystem, then click the button below to choose a model for yourself.
GENUINE LAPTOPS - WITH GENUINE WINDOWS
Check out more:
- Learn how to automatically align rows and columns in Excel that you should know about
- How to check the results of the 2023 National High School Graduation Exam, accurate university admission scores
- Conveniently read documents in Word with virtual voice narration
