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.