Excel Lists - Automatically Changing Information

D

Debs

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:

[email protected]
[email protected]

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

Regards

Debbie
 
O

OssieMac

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
 
O

OssieMac

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
 
R

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.
 
O

OssieMac

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
 
D

Debs

Many thanks everyone - now sorted :)

Debs

Roger Govier said:
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.
Click to expand...
 
Top