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.


Your comment will be posted after it is approved.

Leave a Reply