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
Bookmarks