I have a list of names in one column and need a formula to split the info in
to to two columns ie First Name and then Surname. can anyone help?

If you have a single space separating the first name from the surname,
you can highlight the column then use Data | Text-to-columns and
specify delimited with space as the delimiter.

Hope this helps.

Pete