If you need to combine cells in your CSV report after downloading, (or for fields in a CSV upload) there's a function (formula) you can use called CONCATENATE.
=CONCATENATE(A1, B1, C1)
Example
The CONCATENATE function combines cells (separated by a comma) as text:
A | B | C | D |
Test1 | Test2 | Test3 | =CONCATENATE(A1, B1, C1) |
|
|
|
|
Function applied:
A | B | C | D |
Test1 | Test2 | Test3 | Test1Test2Test3 |
|
|
|
|
How to add spaces and custom characters
For this example, we will be adding commas and spaces between cell values.
Add a cell to the function as normal:
=CONCATENATE(A1,
Next, wrap a comma and space in quotes,
followed by a comma:
=CONCATENATE(A1, ", ",
Add the next cell,
and repeat the ", ", between each cell:
=CONCATENATE(A1, ", ", B1, ", ", C1)
Our result will be:
A | B | C | D |
Test1 | Test2 | Test3 | Test1, Test2, Test3 |
|
|
|
|
Click here to explore a sample Google Sheet of this function, or make a copy:
