Thursday

SharePoint Columns: Extract the First Letter in a Full Name Colum

I was creating a list of names and I needed to extract the first letter in a Full name column that I could use it in a list view grouping so a name can be found easily using the first letter of the surname.

Solution:
1. Create a calculated column (e.g Name Letter)
2. Insert the following formula without the quotes "=LEFT([Surname],1)", where Surname is the column you need to extract the first letter.

Useful links
- http://office.microsoft.com/en-us/excel-help/left-leftb-functions-HP010062568.aspx
- http://sharemypoint.in/2009/03/04/sharepoint-calculated-columns-formulas/

2 comments:

YGY said...

Thanks for sharing... but what if you have one column with "FirstName LastName" and want the formula to retrieve FL, basically initials.

Thanks again.

Bigge said...

=LEFT(Column1,1)&LEFT(Column2,1)