Introduction
Merge values from various ranges and/or strings.
| FORMULA | CONCAT(value1, value2, ...) |
| EXAMPLE FORMULA | CONCAT(user_col, "@gigasheet.com") |
| EXAMPLE INPUT | support |
| EXAMPLE OUTPUT | support@gigasheet.com |
Sample Usage
| Valid Examples | Invalid Examples |
CONCAT(Text Column,Number as Text Data Type) | CONCAT(Number as Text Data Type,"33") |
CONCAT(Text Column,CONCAT(1,2)) | |
| CONCAT(Number Column,"Testy") | |
CONCAT(Date,"Test2") | |
| CONCAT(Number as Text Data Type,33) | |
| CONCAT(Text Column,CONCAT(1,CONCAT(2,3,4))) |
Notes
- CONCAT cannot be used with dates
See Also
Still having issues? Contact us at support@gigasheet.com
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article