Easy steps to combine names in WPS Office Excel
A free Office suite fully compatible with Microsoft Office
A free Office suite fully compatible with Microsoft Office
This free tutorial offered by WPS Official Academy is going to guide you through the easy steps to combine names in WPS Office Excel in a detailed way. You are sure to master this must-have office technique in 5 minutes. Let's get started now!
We may sometimes import a table in which the first names and last names are separated into two columns. At this time, we can consider the CONCATENATE function built in WPS systemas a solution to combine them.
l What is the CONCATENATE function in WPS Office Excel?
The CONCATENATE function is used to combine values in different cells and returns the result as text with delimiter in one single cell.
Ø Syntax
=CONCATENATE(text1, [text2], ...)
Ø Arguements
text1-[required] The first text value to combine.
text2- [optional] The second text value to combine.
Ø Usage Notes
The CONCATENATE function can join up 30 values at most, and the values are combined in the order they appear.
l Steps to combine names in WPS Office Excel
1. Open the excel document in WPS Office.
2. Select cell D2, and click the Insert Function button.
3. In the pop-up dialog, enter CONCATENATE in the search box, and select it.
4. In the Function Arguments dialog, input A2 at Text1 and B2 at Text2, and click OK. Now we can see there is no space between two components of the full name.
5. To add a space, add the argument (two double quotes around a space) in the formula.
6. Finally, drag the fill handle to apply the same function to other cells.
Until now, we have gone through the 6 steps to combine names in WPS Office Excel. What's more, WPS Academy has updated abundant free tutorials almost covering all often used functions in Excel. You're welcome to check them on our official site via the following links.
The RANK function | Free Office Courses
The INDEX function | Free Office Courses
Use SUMIFS function with multiple criteria | Free Office Courses
Excel is the most powerful tool to manage and analyze various types of Data. This free WPS Spreadsheet tutorial for beginners covers in-depth lessons for Excel learning and how to use various Excel formulas, tables and charts for managing small to large scale business process.
Was this helpful?
Yes
No
Trending Tutorials
- 1. How to get month name from a date in Excel (3 easy ways)
- 2. Check if value is in list in Excel (3 easy methods)
- 3. How to Copy File Names in Excel from a Folder?
- 4. How to color cell based on value in Excel?
- 5. How to add text to beginning or end of all cells in Excel
- 6. How to compare two excel sheets and highlight differences