Many thanks everyone - now sorted :-)

Debs

"Roger Govier" wrote:

Hi Debs

Assuming the names are in column A with blank columns to the right
Mark column ADataText to columnsDelimitedDelimiterCommaFinish.
You now have lastname in column A and firstname in column B.
Enter in cell C1 @Dickinson-Dees.com

then in D1 enter
=B1&"."&A1&$C$1
Copy down column D as far as required.
Copy column DPaste SpecialValues to "fix" the data.

--
Regards
Roger Govier



"Debs" wrote in message
...
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