Changing text appearance

M

Max Prophet

If cell A1 contains the text "Jane Doe", and I would like the the adjoining
cell to display as "[email protected]", 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.
 
R

Ron Coderre

Try something like this:

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

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

XL2002, WinXP
 
M

Max Prophet

Like a charm! Thanks.

Ron Coderre said:
Try something like this:

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

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

XL2002, WinXP
Click to expand...
 
Top