Excel Lists - Automatically Changing Information

[Guest]

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:

(e-mail address removed)
(e-mail address removed)

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

Regards

Debbie

 

[Guest]

Hi Debbie,

Assume that Rose, Deborah is in cell A1 then use the following:-

=TRIM(MID(A1,FIND(",",A1)+1,255))&"."&E1&"@"&"Dickinson-Dees.com"

Regards,

OssieMac

 

[Guest]

Hi Debbie,

Assume that Rose, Deborah is in cell A1 then in any other cell
insert the following:-

=TRIM(MID(A1,FIND(",",A1)+1,255))&"."&E1&"@"&"Dickinson-Dees.com"

Regards,

OssieMac

 

[Guest]

Hi thanks for the info! It seems to work but does not add in the surname the
results show as:

(e-mail address removed)

and need to display as:

(e-mail address removed)

Any ideas?

Cheers

Debs

 

[Roger Govier]

Hi Debs

Assuming the names are in column A with blank columns to the right
Mark column A>Data>Text to columns>Delimited>Delimiter>Comma>Finish.
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 D>Paste Special>Values to "fix" the data.

 

[Guest]

Hi again Debbie,

My sincerest apologies. Try this:-

=TRIM(MID(A1,FIND(",",A1)+1,255))&"."&LEFT(A1,FIND(",",A1)-1)&"@"&"Dickinson-Dees.com"


The above is actually one line but it will not fit in properly.


Regards,

OssieMac

 

[Guest]

Many thanks everyone - now sorted

Debs

Hi Debs

Assuming the names are in column A with blank columns to the right
Mark column A>Data>Text to columns>Delimited>Delimiter>Comma>Finish.
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 D>Paste Special>Values to "fix" the data.