Data Re-arrange

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

If you select the column containing the text and from the Data menu select "Text to columns".

This will give the option to split the names based on a space between each name - bear in mind that it will fill the columns to the right so if you have other information in those columns ensure you insert a few extra columns before using the text to columns option.

Hope it helps

Cheers

Tony