Changing text appearance

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Try something like this:

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

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

XL2002, WinXP
 
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...
 
Back
Top