The CONCATENATE Function in Excel
A free Office suite fully compatible with Microsoft Office
WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more.
The concatenate function is one of the text functions, allowing you to join two or more words or text strings together.
In today's case, let's say you have to connect a list of separate first and last names, what you need to do is tojoin text from column A (First Name) with the text from column B (Last Name) and pull them together in Column C (Full Name)
CONCATENATE(text1, [text2], ...)
text1means the first argument to join and can be a number, text, or cell reference.
text2, text3, text4, etc. Those are the additional texts or numbers to combine.
1. Open your table with WPS Spreadsheet.
2. Place your cursor in C2, click the Formula tab > Insert Function > enter CONCATENATE in the edit box.
3. In the pop-up dialog, select cell A2 at Text1, and cell B2 at Text2, you could preview the results in the lower right of the window.
Space between the First and Last name is needed, so we need to reset our CONCATENATE formula with a space in between.
This time, enter Quotes at Text2 and cell B2 at Text3. Don't forget to add quotes. Finally, click OK.
4. If you want to fill the remaining cells in this column, hove over cell C2, and double-click the plus sign (+) in the bottom right-hand corner, you can complete the process.
Was this helpful?
- 1. How to compare two excel sheets and highlight differences
- 2. How to expand cells to fit text in Excel
- 3. How to copy file names in Excel from a folder?
- 4. How to import external data in WPS Spreadsheet
- 5. How to use the VLOOKUP function across multiple sheets in WPS Office Excel?
- 6. Check if value is in list in Excel (3 easy methods)