Hi

I have a list of names in Excel XP which are formatted as:

Rose, Deborah
Culyer, Susan

What I need to do is get them to automatically change to the following format:




Does anyone know of any formulas that would allow me to do this please?

Regards

Debbie