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.

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


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...