Monday

SharePoint Calculated Columns: LEN, LEFT, RIGHT


Using LEN in SharePoint Calculated Columns enables you to count total numbers of Characters in a Column. It can be used as follows;


=LEN([ColumnName]) 
=LEN([Column1]&[Column2])


You can have other permutations such as 


Counts the number of characters in Column1 and remove 4 characters from the left 
=LEFT([Column1],LEN([Column1])-4) 


Counts the number of characters in Column1 and remove 3 characters from the right
=RIGHT([Column1], LEN([Column1])-3)




I hope this helps someone

No comments: