A Practical Guide to SharePoint 2013

A Practical Guide to SharePoint 2013
A Practical Guide to SharePoint 2013 - Book by Saifullah Shafiq

Thursday, September 14, 2006

Text functions for "calculated" field

Q:  Is it possible to get the first letter of a column in calculated field?
Use the Left function to get the first letter.

=LEFT(Column1,1) -> This will return the first character of column1
Instructions:
Suppose you want to get the first letter of "Title" field in document library.
1. Add a new column.
2. Give a name to the new column and select "Calculated" as the type.
3. Type the following formula in the formula box:
    =Left(Title,1)
4. Keep the return data type as "Single line of text" and click "OK".