Use CONCAT function to merge data

Uploaded time: February 7, 2022 Difficulty Beginner

A free Office suite fully compatible with Microsoft Office

Free Download

Use CONCAT function to merge data

Use CONCAT function to merge data

We can use the CONCAT function to merge the contents of multiple cells.

This function is mainly applied to merge character strings within a certain cell range or in different cells.

Now we take a simple case as an example. We want to merge the domain names to form a complete website address.

1. Click Formulas, click Insert Function, input CONCAT in the dialog, and click OK.


2. Since the cells to be combined are continuous, we input A2:D2 in Text 1, click OK, and drag the cell to fill the rest.


Now we come to another case. We want to merge the names of Column A with the sentence of cell C2 and add a separator between them.

1. Insert the CONCAT function again and input A2 in Text 1.

2. Input the desired separator in Text 2 and mark it with quotes.

3. Input C2 in Text 3. In this case, we need an absolute reference to cell C2, so press the shortcut key F4to apply it.

4. Lastly, click OK and drag the cell to fill the rest.

WPS Office Spreadsheet is helpful for various fields of studies: mathematics, statistics, data science, engineering, finance, and such. Rich functions paired with teaching procedures, WPS Office Spreadsheet definitely is a professional and reliable toolkit.