I have a calculated column [lastname] with the following formula:
=RIGHT([Staff Name],LEN([Staff Name])-INT(FIND(" ",[Staff Name])))
[Staff Name] is generated by SharePoint Designer (from another list) which is basically concatenating the first and last name from an email address.
If two or more individuals share the same first and last names, a number is added to the last name. i.e. First.Last1@domain.com
Is there a way I can extract only the letters in the last name?