WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

The CONCATENATE Function in Excel

February 13, 2023
10.2K Views

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more.

· Description:

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)

· Syntax

CONCATENATE(text1, [text2], ...)

· Argument:

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.

· Example

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.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.