I have a spreadsheet of 400 names consisting of first name, middle initial
and surname (e.g. Joe x Blogs) and want to create a new column that just
gives me the surname. I'm sure that it can be done with the Right function
but just can't find the correct method to do it. Any help appreciated. Thanks