Free All-in-One Office Suite with PDF Editor
Edit Word, Excel, and PPT for FREE.
Read, edit, and convert PDFs with the powerful PDF toolkit.
Microsoft-like interface, easy to use.
Windows • MacOS • Linux • iOS • Android
Use CONCAT function to merge data
Uploaded time: February 7, 2022 Difficulty Beginner
Use CONCAT function to merge data
![](http://res-academy.cache.wpscdn.com/static/cover/big_xls.png)
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.
Also Read:
- 1. AVERAGE function quickly average data
- 2. Change horizontal data to vertical and make data clearer
- 3. Use the Mail Merge function to input tabular data quickly
- 4. Look up data quickly with LOOKUP function
- 5. Use IF function to judge data
- 6. SUBTOTAL function: Calculate the data with the hidden value
Does this video help you?