Hi, I have a list of names such as:

SAARI Mohd Fadzli
SALAMAN Norizam
SYED HUSSEIN Syed Adney

and so on, each name is in a unique cell, The capitalised part is the surname and the lowercase the first name; I need to have each name in a unique cell with all names Title case with first name first and surname second, so the results are:

Mohd Fadzli Saari
Norizam Salaman
Syed Adney Syed Hussein

Is there any way this can be done as a formula or macro? I am having problems as there is more than one word making up each name part? Thanks in advance