=PROPER(B1&" "&REPLACE(A1,FIND(B1,A1),LEN(B1),""))
"Angel Eyes" wrote:

I have a list of names, surname followed by the christiam name in one cell,
EG; Smith, Tom. Is there a way of highlighting all cells in this format so
that they are then displayed as christian name followed by surname.