We have used the formula below to concatenate information such as document name and version, or to create unique IDs in SharePoint.

1. Create a Calculated value column

2. Use the formula below,


Replace the generic ColumnName1 and ColumnName2 in the example above with the name of your respective columns.