The CONCATENATE Function in Excel

December 13, 2021
0.2251 Views

A free Office suite fully compatible with Microsoft Office

Free Download

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. 

How to CONCATENATE in Excel2.gif

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.

How to CONCATENATE in Excel3.gif

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.

How to CONCATENATE in Excel4.gif

Was this helpful?