Changing text appearance

[Guest]

If cell A1 contains the text "Jane Doe", and I would like the the adjoining
cell to display as "(e-mail address removed)", how would I go about doing
that? I basically have a column of data (first name and last names) I would
like to format in that manner.

Thanks in advance for any advice.

 

[Guest]

Try something like this:

With
A1: Jane Doe
B1: =SUBSTITUTE(A1," ",".")&"@generic.email.net"

Does that help?
***********
Regards,
Ron

XL2002, WinXP

 

[Guest]

Like a charm! Thanks.

Try something like this:

With
A1: Jane Doe
B1: =SUBSTITUTE(A1," ",".")&"@generic.email.net"

Does that help?
***********
Regards,
Ron

XL2002, WinXP

 

[Guest]

=LOWER(SUBSTITUTE(A1," ","."))&"@generic.email.net"